Mac Easy 2010 May

home *** CD-ROM | disk | FTP | other *** search
/ Mac Easy 2010 May / Mac Life Ubuntu.iso / casper / filesystem.squashfs / usr / share / locale-langpack / de / LC_MESSAGES / gnumeric-functions.mo < prev next >
Gettext Machine Object | 2009-04-17 | 361.9 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was processed as: Gettext Machine Object (other/gettextMachineObject).
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`1%`	dexvert	Gettext Machine Object `(other/gettextMachineObject)`	magic	Unsupported
`100%`	file	GNU message catalog (little endian), revision 0.0, 394 messages, Project-Id-Version: gnumeric 1.2.2 '@FUNCTION=ABS'	default
`99%`	file	data	default
`100%`	TrID	GNU Gettext Machine Object (litte endian)	default
`100%`	detectItEasy	Format: GNU Gettext Machine Object (.MO)	default
`100%`	xdgMime	application/x-gettext-translation	default
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| de 12 04 95 00 00 00 00 | 8a 01 00 00 1c 00 00 00 |........|........|
|00000010| 6c 0c 00 00 1d 02 00 00 | bc 18 00 00 00 00 00 00 |l.......|........|
|00000020| 30 21 00 00 4c 01 00 00 | 31 21 00 00 15 05 00 00 |0!..L...|1!......|
|00000030| 7e 22 00 00 b2 03 00 00 | 94 27 00 00 7b 01 00 00 |~"......|.'..{...|
|00000040| 47 2b 00 00 6b 01 00 00 | c3 2c 00 00 c8 03 00 00 |G+..k...|.,......|
|00000050| 2f 2e 00 00 4b 04 00 00 | f8 31 00 00 c0 03 00 00 |/...K...|.1......|
|00000060| 44 36 00 00 b7 00 00 00 | 05 3a 00 00 55 01 00 00 |D6......|.:..U...|
|00000070| bd 3a 00 00 35 01 00 00 | 13 3c 00 00 30 01 00 00 |.:..5...|.<..0...|
|00000080| 49 3d 00 00 d4 01 00 00 | 7a 3e 00 00 87 01 00 00 |I=......|z>......|
|00000090| 4f 40 00 00 50 01 00 00 | d7 41 00 00 bb 01 00 00 |O@..P...|.A......|
|000000a0| 28 43 00 00 5e 02 00 00 | e4 44 00 00 a0 01 00 00 |(C..^...|.D......|
|000000b0| 43 47 00 00 4f 01 00 00 | e4 48 00 00 ae 01 00 00 |CG..O...|.H......|
|000000c0| 34 4a 00 00 ba 01 00 00 | e3 4b 00 00 26 02 00 00 |4J......|.K..&...|
|000000d0| 9e 4d 00 00 2c 02 00 00 | c5 4f 00 00 32 01 00 00 |.M..,...|.O..2...|
|000000e0| f2 51 00 00 f7 00 00 00 | 25 53 00 00 82 01 00 00 |.Q......|%S......|
|000000f0| 1d 54 00 00 7c 01 00 00 | a0 55 00 00 97 02 00 00 |.T..|...|.U......|
|00000100| 1d 57 00 00 8d 00 00 00 | b5 59 00 00 d2 00 00 00 |.W......|.Y......|
|00000110| 43 5a 00 00 8a 00 00 00 | 16 5b 00 00 d2 00 00 00 |CZ......|.[......|
|00000120| a1 5b 00 00 96 00 00 00 | 74 5c 00 00 64 01 00 00 |.[......|t\..d...|
|00000130| 0b 5d 00 00 d8 00 00 00 | 70 5e 00 00 ab 01 00 00 |.]......|p^......|
|00000140| 49 5f 00 00 ff 02 00 00 | f5 60 00 00 98 00 00 00 |I_......|.`......|
|00000150| f5 63 00 00 77 01 00 00 | 8e 64 00 00 43 01 00 00 |.c..w...|.d..C...|
|00000160| 06 66 00 00 7f 01 00 00 | 4a 67 00 00 41 01 00 00 |.f......|Jg..A...|
|00000170| ca 68 00 00 cc 00 00 00 | 0c 6a 00 00 bb 00 00 00 |.h......|.j......|
|00000180| d9 6a 00 00 18 01 00 00 | 95 6b 00 00 24 01 00 00 |.j......|.k..$...|
|00000190| ae 6c 00 00 52 01 00 00 | d3 6d 00 00 b7 01 00 00 |.l..R...|.m......|
|000001a0| 26 6f 00 00 0e 01 00 00 | de 70 00 00 ee 01 00 00 |&o......|.p......|
|000001b0| ed 71 00 00 c5 01 00 00 | dc 73 00 00 09 01 00 00 |.q......|.s......|
|000001c0| a2 75 00 00 52 01 00 00 | ac 76 00 00 45 01 00 00 |.u..R...|.v..E...|
|000001d0| ff 77 00 00 7a 01 00 00 | 45 79 00 00 f6 00 00 00 |.w..z...|Ey......|
|000001e0| c0 7a 00 00 bc 01 00 00 | b7 7b 00 00 2f 04 00 00 |.z......|.{../...|
|000001f0| 74 7d 00 00 52 04 00 00 | a4 81 00 00 27 04 00 00 |t}..R...|....'...|
|00000200| f7 85 00 00 09 04 00 00 | 1f 8a 00 00 04 04 00 00 |........|........|
|00000210| 29 8e 00 00 09 04 00 00 | 2e 92 00 00 b0 01 00 00 |).......|........|
|00000220| 38 96 00 00 57 02 00 00 | e9 97 00 00 c2 00 00 00 |8...W...|........|
|00000230| 41 9a 00 00 3f 02 00 00 | 04 9b 00 00 4a 02 00 00 |A...?...|....J...|
|00000240| 44 9d 00 00 62 01 00 00 | 8f 9f 00 00 27 02 00 00 |D...b...|....'...|
|00000250| f2 a0 00 00 24 01 00 00 | 1a a3 00 00 38 03 00 00 |....$...|....8...|
|00000260| 3f a4 00 00 ab 01 00 00 | 78 a7 00 00 82 07 00 00 |?.......|x.......|
|00000270| 24 a9 00 00 48 01 00 00 | a7 b0 00 00 b5 03 00 00 |$...H...|........|
|00000280| f0 b1 00 00 3b 07 00 00 | a6 b5 00 00 3c 07 00 00 |....;...|....<...|
|00000290| e2 bc 00 00 7d 01 00 00 | 1f c4 00 00 7e 01 00 00 |....}...|....~...|
|000002a0| 9d c5 00 00 79 01 00 00 | 1c c7 00 00 0a 01 00 00 |....y...|........|
|000002b0| 96 c8 00 00 d8 00 00 00 | a1 c9 00 00 58 01 00 00 |........|....X...|
|000002c0| 7a ca 00 00 7b 01 00 00 | d3 cb 00 00 93 07 00 00 |z...{...|........|
|000002d0| 4f cd 00 00 4e 03 00 00 | e3 d4 00 00 20 07 00 00 |O...N...|.... ...|
|000002e0| 32 d8 00 00 fb 06 00 00 | 53 df 00 00 d9 00 00 00 |2.......|S.......|
|000002f0| 4f e6 00 00 a6 01 00 00 | 29 e7 00 00 21 01 00 00 |O.......|)...!...|
|00000300| d0 e8 00 00 e4 06 00 00 | f2 e9 00 00 fe 06 00 00 |........|........|
|00000310| d7 f0 00 00 5f 03 00 00 | d6 f7 00 00 e6 01 00 00 |...._...|........|
|00000320| 36 fb 00 00 3d 03 00 00 | 1d fd 00 00 7a 01 00 00 |6...=...|....z...|
|00000330| 5b 00 01 00 1e 03 00 00 | d6 01 01 00 47 01 00 00 |[.......|....G...|
|00000340| f5 04 01 00 85 00 00 00 | 3d 06 01 00 61 01 00 00 |........|=...a...|
|00000350| c3 06 01 00 1a 02 00 00 | 25 08 01 00 b4 02 00 00 |........|%.......|
|00000360| 40 0a 01 00 08 01 00 00 | f5 0c 01 00 2a 01 00 00 |@.......|....*...|
|00000370| fe 0d 01 00 0a 02 00 00 | 29 0f 01 00 e6 00 00 00 |........|).......|
|00000380| 34 11 01 00 bb 00 00 00 | 1b 12 01 00 8d 01 00 00 |4.......|........|
|00000390| d7 12 01 00 d9 01 00 00 | 65 14 01 00 34 01 00 00 |........|e...4...|
|000003a0| 3f 16 01 00 bc 00 00 00 | 74 17 01 00 4b 01 00 00 |?.......|t...K...|
|000003b0| 31 18 01 00 a6 00 00 00 | 7d 19 01 00 8a 01 00 00 |1.......|}.......|
|000003c0| 24 1a 01 00 ee 00 00 00 | af 1b 01 00 37 01 00 00 |$.......|....7...|
|000003d0| 9e 1c 01 00 44 01 00 00 | d6 1d 01 00 38 01 00 00 |....D...|....8...|
|000003e0| 1b 1f 01 00 1a 01 00 00 | 54 20 01 00 3f 01 00 00 |........|T ..?...|
|000003f0| 6f 21 01 00 cf 02 00 00 | af 22 01 00 06 02 00 00 |o!......|."......|
|00000400| 7f 25 01 00 cc 01 00 00 | 86 27 01 00 12 02 00 00 |.%......|.'......|
|00000410| 53 29 01 00 04 02 00 00 | 66 2b 01 00 c2 01 00 00 |S)......|f+......|
|00000420| 6b 2d 01 00 68 01 00 00 | 2e 2f 01 00 45 01 00 00 |k-..h...|./..E...|
|00000430| 97 30 01 00 69 01 00 00 | dd 31 01 00 83 01 00 00 |.0..i...|.1......|
|00000440| 47 33 01 00 9b 01 00 00 | cb 34 01 00 02 01 00 00 |G3......|.4......|
|00000450| 67 36 01 00 71 01 00 00 | 6a 37 01 00 16 01 00 00 |g6..q...|j7......|
|00000460| dc 38 01 00 a0 01 00 00 | f3 39 01 00 84 01 00 00 |.8......|.9......|
|00000470| 94 3b 01 00 ea 00 00 00 | 19 3d 01 00 80 01 00 00 |.;......|.=......|
|00000480| 04 3e 01 00 97 01 00 00 | 85 3f 01 00 ec 00 00 00 |.>......|.?......|
|00000490| 1d 41 01 00 91 02 00 00 | 0a 42 01 00 d5 01 00 00 |.A......|.B......|
|000004a0| 9c 44 01 00 20 01 00 00 | 72 46 01 00 24 01 00 00 |.D.. ...|rF..$...|
|000004b0| 93 47 01 00 69 01 00 00 | b8 48 01 00 66 01 00 00 |.G..i...|.H..f...|
|000004c0| 22 4a 01 00 4a 01 00 00 | 89 4b 01 00 60 01 00 00 |"J..J...|.K..`...|
|000004d0| d4 4c 01 00 4b 01 00 00 | 35 4e 01 00 5d 01 00 00 |.L..K...|5N..]...|
|000004e0| 81 4f 01 00 48 01 00 00 | df 50 01 00 5b 01 00 00 |.O..H...|.P..[...|
|000004f0| 28 52 01 00 67 01 00 00 | 84 53 01 00 73 01 00 00 |(R..g...|.S..s...|
|00000500| ec 54 01 00 65 01 00 00 | 60 56 01 00 7d 01 00 00 |.T..e...|`V..}...|
|00000510| c6 57 01 00 92 01 00 00 | 44 59 01 00 3a 01 00 00 |.W......|DY..:...|
|00000520| d7 5a 01 00 1b 01 00 00 | 12 5c 01 00 46 01 00 00 |.Z......|.\..F...|
|00000530| 2e 5d 01 00 2c 01 00 00 | 75 5e 01 00 3f 01 00 00 |.]..,...|u^..?...|
|00000540| a2 5f 01 00 2a 01 00 00 | e2 60 01 00 3e 01 00 00 |._..*...|.`..>...|
|00000550| 0d 62 01 00 32 01 00 00 | 4c 63 01 00 19 01 00 00 |.b..2...|Lc......|
|00000560| 7f 64 01 00 f6 01 00 00 | 99 65 01 00 2d 01 00 00 |.d......|.e..-...|
|00000570| 90 67 01 00 2c 01 00 00 | be 68 01 00 09 01 00 00 |.g..,...|.h......|
|00000580| eb 69 01 00 a4 01 00 00 | f5 6a 01 00 44 01 00 00 |.i......|.j..D...|
|00000590| 9a 6c 01 00 14 01 00 00 | df 6d 01 00 29 01 00 00 |.l......|.m..)...|
|000005a0| f4 6e 01 00 3d 01 00 00 | 1e 70 01 00 17 01 00 00 |.n..=...|.p......|
|000005b0| 5c 71 01 00 43 01 00 00 | 74 72 01 00 21 01 00 00 |\q..C...|tr..!...|
|000005c0| b8 73 01 00 2c 01 00 00 | da 74 01 00 27 01 00 00 |.s..,...|.t..'...|
|000005d0| 07 76 01 00 1f 01 00 00 | 2f 77 01 00 44 01 00 00 |.v......|/w..D...|
|000005e0| 4f 78 01 00 fa 01 00 00 | 94 79 01 00 0a 03 00 00 |Ox......|.y......|
|000005f0| 8f 7b 01 00 fb 00 00 00 | 9a 7e 01 00 84 02 00 00 |.{......|.~......|
|00000600| 96 7f 01 00 ab 00 00 00 | 1b 82 01 00 cf 00 00 00 |........|........|
|00000610| c7 82 01 00 cf 00 00 00 | 97 83 01 00 b7 00 00 00 |........|........|
|00000620| 67 84 01 00 bd 00 00 00 | 1f 85 01 00 be 00 00 00 |g.......|........|
|00000630| dd 85 01 00 cd 00 00 00 | 9c 86 01 00 c3 00 00 00 |........|........|
|00000640| 6a 87 01 00 b3 00 00 00 | 2e 88 01 00 39 02 00 00 |j.......|....9...|
|00000650| e2 88 01 00 41 02 00 00 | 1c 8b 01 00 cc 00 00 00 |....A...|........|
|00000660| 5e 8d 01 00 a1 00 00 00 | 2b 8e 01 00 b5 00 00 00 |^.......|+.......|
|00000670| cd 8e 01 00 bf 00 00 00 | 83 8f 01 00 81 00 00 00 |........|........|
|00000680| 43 90 01 00 90 02 00 00 | c5 90 01 00 ac 01 00 00 |C.......|........|
|00000690| 56 93 01 00 cb 00 00 00 | 03 95 01 00 bf 00 00 00 |V.......|........|
|000006a0| cf 95 01 00 09 01 00 00 | 8f 96 01 00 d1 00 00 00 |........|........|
|000006b0| 99 97 01 00 cf 00 00 00 | 6b 98 01 00 d8 00 00 00 |........|k.......|
|000006c0| 3b 99 01 00 e0 00 00 00 | 14 9a 01 00 47 01 00 00 |;.......|....G...|
|000006d0| f5 9a 01 00 e8 00 00 00 | 3d 9c 01 00 ba 00 00 00 |........|=.......|
|000006e0| 26 9d 01 00 fb 01 00 00 | e1 9d 01 00 d2 00 00 00 |&.......|........|
|000006f0| dd 9f 01 00 fd 01 00 00 | b0 a0 01 00 07 02 00 00 |........|........|
|00000700| ae a2 01 00 dc 00 00 00 | b6 a4 01 00 dd 02 00 00 |........|........|
|00000710| 93 a5 01 00 8a 01 00 00 | 71 a8 01 00 54 02 00 00 |........|q...T...|
|00000720| fc a9 01 00 d8 01 00 00 | 51 ac 01 00 ac 02 00 00 |........|Q.......|
|00000730| 2a ae 01 00 dd 01 00 00 | d7 b0 01 00 fc 00 00 00 |*.......|........|
|00000740| b5 b2 01 00 8b 01 00 00 | b2 b3 01 00 52 02 00 00 |........|....R...|
|00000750| 3e b5 01 00 86 01 00 00 | 91 b7 01 00 5b 01 00 00 |>.......|....[...|
|00000760| 18 b9 01 00 c0 00 00 00 | 74 ba 01 00 2b 01 00 00 |........|t...+...|
|00000770| 35 bb 01 00 20 01 00 00 | 61 bc 01 00 fd 01 00 00 |5... ...|a.......|
|00000780| 82 bd 01 00 4b 01 00 00 | 80 bf 01 00 cd 01 00 00 |....K...|........|
|00000790| cc c0 01 00 0c 01 00 00 | 9a c2 01 00 dc 00 00 00 |........|........|
|000007a0| a7 c3 01 00 a0 00 00 00 | 84 c4 01 00 21 02 00 00 |........|....!...|
|000007b0| 25 c5 01 00 ba 01 00 00 | 47 c7 01 00 a4 01 00 00 |%.......|G.......|
|000007c0| 02 c9 01 00 0f 02 00 00 | a7 ca 01 00 18 01 00 00 |........|........|
|000007d0| b7 cc 01 00 8f 01 00 00 | d0 cd 01 00 12 01 00 00 |........|........|
|000007e0| 60 cf 01 00 86 01 00 00 | 73 d0 01 00 92 00 00 00 |`.......|s.......|
|000007f0| fa d1 01 00 65 01 00 00 | 8d d2 01 00 c9 00 00 00 |....e...|........|
|00000800| f3 d3 01 00 a9 00 00 00 | bd d4 01 00 9b 00 00 00 |........|........|
|00000810| 67 d5 01 00 82 01 00 00 | 03 d6 01 00 fc 00 00 00 |g.......|........|
|00000820| 86 d7 01 00 7f 01 00 00 | 83 d8 01 00 04 01 00 00 |........|........|
|00000830| 03 da 01 00 74 03 00 00 | 08 db 01 00 17 03 00 00 |....t...|........|
|00000840| 7d de 01 00 2f 03 00 00 | 95 e1 01 00 11 03 00 00 |}.../...|........|
|00000850| c5 e4 01 00 b8 01 00 00 | d7 e7 01 00 15 03 00 00 |........|........|
|00000860| 90 e9 01 00 f0 03 00 00 | a6 ec 01 00 27 03 00 00 |........|....'...|
|00000870| 97 f0 01 00 ad 03 00 00 | bf f3 01 00 90 03 00 00 |........|........|
|00000880| 6d f7 01 00 ac 03 00 00 | fe fa 01 00 92 03 00 00 |m.......|........|
|00000890| ab fe 01 00 86 03 00 00 | 3e 02 02 00 d9 03 00 00 |........|>.......|
|000008a0| c5 05 02 00 f9 02 00 00 | 9f 09 02 00 d3 02 00 00 |........|........|
|000008b0| 99 0c 02 00 d0 00 00 00 | 6d 0f 02 00 0e 01 00 00 |........|m.......|
|000008c0| 3e 10 02 00 19 02 00 00 | 4d 11 02 00 5f 01 00 00 |>.......|M..._...|
|000008d0| 67 13 02 00 da 00 00 00 | c7 14 02 00 0b 01 00 00 |g.......|........|
|000008e0| a2 15 02 00 42 02 00 00 | ae 16 02 00 ff 01 00 00 |....B...|........|
|000008f0| f1 18 02 00 c7 02 00 00 | f1 1a 02 00 b2 03 00 00 |........|........|
|00000900| b9 1d 02 00 a7 03 00 00 | 6c 21 02 00 7c 02 00 00 |........|l!..|...|
|00000910| 14 25 02 00 eb 00 00 00 | 91 27 02 00 d1 01 00 00 |.%......|.'......|
|00000920| 7d 28 02 00 17 03 00 00 | 4f 2a 02 00 21 01 00 00 |}(......|O*..!...|
|00000930| 67 2d 02 00 d6 00 00 00 | 89 2e 02 00 e9 00 00 00 |g-......|........|
|00000940| 60 2f 02 00 ef 00 00 00 | 4a 30 02 00 9c 00 00 00 |`/......|J0......|
|00000950| 3a 31 02 00 15 01 00 00 | d7 31 02 00 1f 01 00 00 |:1......|.1......|
|00000960| ed 32 02 00 a5 00 00 00 | 0d 34 02 00 89 02 00 00 |.2......|.4......|
|00000970| b3 34 02 00 a1 00 00 00 | 3d 37 02 00 c2 01 00 00 |.4......|=7......|
|00000980| df 37 02 00 a1 00 00 00 | a2 39 02 00 c4 00 00 00 |.7......|.9......|
|00000990| 44 3a 02 00 76 01 00 00 | 09 3b 02 00 7a 01 00 00 |D:..v...|.;..z...|
|000009a0| 80 3c 02 00 73 01 00 00 | fb 3d 02 00 f8 01 00 00 |.<..s...|.=......|
|000009b0| 6f 3f 02 00 f3 00 00 00 | 68 41 02 00 c2 01 00 00 |o?......|hA......|
|000009c0| 5c 42 02 00 c8 00 00 00 | 1f 44 02 00 10 01 00 00 |\B......|.D......|
|000009d0| e8 44 02 00 aa 00 00 00 | f9 45 02 00 36 01 00 00 |.D......|.E..6...|
|000009e0| a4 46 02 00 ca 00 00 00 | db 47 02 00 d5 02 00 00 |.F......|.G......|
|000009f0| a6 48 02 00 9c 00 00 00 | 7c 4b 02 00 e1 00 00 00 |.H......||K......|
|00000a00| 19 4c 02 00 a6 00 00 00 | fb 4c 02 00 74 01 00 00 |.L......|.L..t...|
|00000a10| a2 4d 02 00 92 00 00 00 | 17 4f 02 00 ac 01 00 00 |.M......|.O......|
|00000a20| aa 4f 02 00 a1 00 00 00 | 57 51 02 00 17 02 00 00 |.O......|WQ......|
|00000a30| f9 51 02 00 da 00 00 00 | 11 54 02 00 0c 01 00 00 |.Q......|.T......|
|00000a40| ec 54 02 00 6a 03 00 00 | f9 55 02 00 14 01 00 00 |.T..j...|.U......|
|00000a50| 64 59 02 00 c1 00 00 00 | 79 5a 02 00 20 01 00 00 |dY......|yZ.. ...|
|00000a60| 3b 5b 02 00 c7 02 00 00 | 5c 5c 02 00 86 02 00 00 |;[......|\\......|
|00000a70| 24 5f 02 00 ca 02 00 00 | ab 61 02 00 cb 02 00 00 |$_......|.a......|
|00000a80| 76 64 02 00 16 01 00 00 | 42 67 02 00 2e 01 00 00 |vd......|Bg......|
|00000a90| 59 68 02 00 62 03 00 00 | 88 69 02 00 87 01 00 00 |Yh..b...|.i......|
|00000aa0| eb 6c 02 00 39 02 00 00 | 73 6e 02 00 17 01 00 00 |.l..9...|sn......|
|00000ab0| ad 70 02 00 ef 00 00 00 | c5 71 02 00 23 01 00 00 |.p......|.q..#...|
|00000ac0| b5 72 02 00 61 02 00 00 | d9 73 02 00 92 01 00 00 |.r..a...|.s......|
|00000ad0| 3b 76 02 00 8b 01 00 00 | ce 77 02 00 e3 00 00 00 |;v......|.w......|
|00000ae0| 5a 79 02 00 d8 00 00 00 | 3e 7a 02 00 86 02 00 00 |Zy......|>z......|
|00000af0| 17 7b 02 00 90 01 00 00 | 9e 7d 02 00 55 02 00 00 |.{......|.}..U...|
|00000b00| 2f 7f 02 00 65 03 00 00 | 85 81 02 00 8b 01 00 00 |/...e...|........|
|00000b10| eb 84 02 00 ad 02 00 00 | 77 86 02 00 29 02 00 00 |........|w...)...|
|00000b20| 25 89 02 00 5b 01 00 00 | 4f 8b 02 00 d1 02 00 00 |%...[...|O.......|
|00000b30| ab 8c 02 00 11 02 00 00 | 7d 8f 02 00 79 02 00 00 |........|}...y...|
|00000b40| 8f 91 02 00 5e 01 00 00 | 09 94 02 00 d2 02 00 00 |....^...|........|
|00000b50| 68 95 02 00 ca 02 00 00 | 3b 98 02 00 ce 02 00 00 |h.......|;.......|
|00000b60| 06 9b 02 00 f0 00 00 00 | d5 9d 02 00 f2 00 00 00 |........|........|
|00000b70| c6 9e 02 00 1d 01 00 00 | b9 9f 02 00 28 01 00 00 |........|....(...|
|00000b80| d7 a0 02 00 d5 00 00 00 | 00 a2 02 00 26 01 00 00 |........|....&...|
|00000b90| d6 a2 02 00 0c 01 00 00 | fd a3 02 00 95 00 00 00 |........|........|
|00000ba0| 0a a5 02 00 df 03 00 00 | a0 a5 02 00 eb 00 00 00 |........|........|
|00000bb0| 80 a9 02 00 a1 00 00 00 | 6c aa 02 00 79 01 00 00 |........|l...y...|
|00000bc0| 0e ab 02 00 7e 04 00 00 | 88 ac 02 00 0e 01 00 00 |....~...|........|
|00000bd0| 07 b1 02 00 d9 00 00 00 | 16 b2 02 00 b1 00 00 00 |........|........|
|00000be0| f0 b2 02 00 ee 00 00 00 | a2 b3 02 00 d4 00 00 00 |........|........|
|00000bf0| 91 b4 02 00 c3 00 00 00 | 66 b5 02 00 eb 01 00 00 |........|f.......|
|00000c00| 2a b6 02 00 15 03 00 00 | 16 b8 02 00 44 01 00 00 |*.......|....D...|
|00000c10| 2c bb 02 00 83 02 00 00 | 71 bc 02 00 1b 02 00 00 |,.......|q.......|
|00000c20| f5 be 02 00 78 02 00 00 | 11 c1 02 00 67 02 00 00 |....x...|....g...|
|00000c30| 8a c3 02 00 f8 01 00 00 | f2 c5 02 00 bc 01 00 00 |........|........|
|00000c40| eb c7 02 00 9e 01 00 00 | a8 c9 02 00 4a 01 00 00 |........|....J...|
|00000c50| 47 cb 02 00 d2 00 00 00 | 92 cc 02 00 97 02 00 00 |G.......|........|
|00000c60| 65 cd 02 00 f0 02 00 00 | fd cf 02 00 9c 01 00 00 |e.......|........|
|00000c70| ee d2 02 00 4c 01 00 00 | 8b d4 02 00 4e 03 00 00 |....L...|....N...|
|00000c80| d8 d5 02 00 4e 03 00 00 | 27 d9 02 00 8d 01 00 00 |....N...|'.......|
|00000c90| 76 dc 02 00 8d 01 00 00 | 04 de 02 00 73 04 00 00 |v.......|....s...|
|00000ca0| 92 df 02 00 4e 03 00 00 | 06 e4 02 00 4e 03 00 00 |....N...|....N...|
|00000cb0| 55 e7 02 00 d0 00 00 00 | a4 ea 02 00 67 01 00 00 |U.......|....g...|
|00000cc0| 75 eb 02 00 51 01 00 00 | dd ec 02 00 3a 01 00 00 |u...Q...|....:...|
|00000cd0| 2f ee 02 00 f5 01 00 00 | 6a ef 02 00 ad 01 00 00 |/.......|j.......|
|00000ce0| 60 f1 02 00 5f 01 00 00 | 0e f3 02 00 be 01 00 00 |`..._...|........|
|00000cf0| 6e f4 02 00 8b 02 00 00 | 2d f6 02 00 ed 00 00 00 |n.......|-.......|
|00000d00| b9 f8 02 00 9d 01 00 00 | a7 f9 02 00 08 02 00 00 |........|........|
|00000d10| 45 fb 02 00 1b 02 00 00 | 4e fd 02 00 62 02 00 00 |E.......|N...b...|
|00000d20| 6a ff 02 00 81 02 00 00 | cd 01 03 00 07 01 00 00 |j.......|........|
|00000d30| 4f 04 03 00 e9 00 00 00 | 57 05 03 00 d2 01 00 00 |O.......|W.......|
|00000d40| 41 06 03 00 d0 01 00 00 | 14 08 03 00 2b 03 00 00 |A.......|....+...|
|00000d50| e5 09 03 00 ae 00 00 00 | 11 0d 03 00 14 01 00 00 |........|........|
|00000d60| c0 0d 03 00 b1 00 00 00 | d5 0e 03 00 14 01 00 00 |........|........|
|00000d70| 87 0f 03 00 be 00 00 00 | 9c 10 03 00 7f 01 00 00 |........|........|
|00000d80| 5b 11 03 00 10 01 00 00 | db 12 03 00 cd 01 00 00 |[.......|........|
|00000d90| ec 13 03 00 fd 02 00 00 | ba 15 03 00 a5 00 00 00 |........|........|
|00000da0| b8 18 03 00 bf 01 00 00 | 5e 19 03 00 7a 01 00 00 |........|^...z...|
|00000db0| 1e 1b 03 00 a2 01 00 00 | 99 1c 03 00 61 01 00 00 |........|....a...|
|00000dc0| 3c 1e 03 00 fb 00 00 00 | 9e 1f 03 00 c4 00 00 00 |<.......|........|
|00000dd0| 9a 20 03 00 23 01 00 00 | 5f 21 03 00 27 01 00 00 |. ..#...|_!..'...|
|00000de0| 83 22 03 00 95 01 00 00 | ab 23 03 00 ac 01 00 00 |."......|.#......|
|00000df0| 41 25 03 00 1f 01 00 00 | ee 26 03 00 43 02 00 00 |A%......|.&..C...|
|00000e00| 0e 28 03 00 d6 01 00 00 | 52 2a 03 00 13 01 00 00 |.(......|R*......|
|00000e10| 29 2c 03 00 84 01 00 00 | 3d 2d 03 00 d5 00 00 00 |),......|=-......|
|00000e20| c2 2e 03 00 79 01 00 00 | 98 2f 03 00 16 01 00 00 |....y...|./......|
|00000e30| 12 31 03 00 ed 01 00 00 | 29 32 03 00 83 04 00 00 |.1......|)2......|
|00000e40| 17 34 03 00 b7 04 00 00 | 9b 38 03 00 83 04 00 00 |.4......|.8......|
|00000e50| 53 3d 03 00 83 04 00 00 | d7 41 03 00 b7 04 00 00 |S=......|.A......|
|00000e60| 5b 46 03 00 83 04 00 00 | 13 4b 03 00 bd 01 00 00 |[F......|.K......|
|00000e70| 97 4f 03 00 2b 03 00 00 | 55 51 03 00 db 00 00 00 |.O..+...|UQ......|
|00000e80| 81 54 03 00 e4 02 00 00 | 5d 55 03 00 e7 02 00 00 |.T......|]U......|
|00000e90| 42 58 03 00 6b 01 00 00 | 2a 5b 03 00 4d 02 00 00 |BX..k...|*[..M...|
|00000ea0| 96 5c 03 00 3f 01 00 00 | e4 5e 03 00 6a 03 00 00 |.\..?...|.^..j...|
|00000eb0| 24 60 03 00 de 01 00 00 | 8f 63 03 00 2f 08 00 00 |$`......|.c../...|
|00000ec0| 6e 65 03 00 73 01 00 00 | 9e 6d 03 00 30 04 00 00 |ne..s...|.m..0...|
|00000ed0| 12 6f 03 00 d4 07 00 00 | 43 73 03 00 d5 07 00 00 |.o......|Cs......|
|00000ee0| 18 7b 03 00 cf 01 00 00 | ee 82 03 00 c6 01 00 00 |.{......|........|
|00000ef0| be 84 03 00 cf 01 00 00 | 85 86 03 00 ed 00 00 00 |........|........|
|00000f00| 55 88 03 00 c9 00 00 00 | 43 89 03 00 97 01 00 00 |U.......|C.......|
|00000f10| 0d 8a 03 00 a0 01 00 00 | a5 8b 03 00 50 08 00 00 |........|....P...|
|00000f20| 46 8d 03 00 4e 03 00 00 | 97 95 03 00 af 07 00 00 |F...N...|........|
|00000f30| e6 98 03 00 85 07 00 00 | 96 a0 03 00 df 00 00 00 |........|........|
|00000f40| 1c a8 03 00 ac 01 00 00 | fc a8 03 00 59 01 00 00 |........|....Y...|
|00000f50| a9 aa 03 00 71 07 00 00 | 03 ac 03 00 97 07 00 00 |....q...|........|
|00000f60| 75 b3 03 00 4e 03 00 00 | 0d bb 03 00 18 02 00 00 |u...N...|........|
|00000f70| 5c be 03 00 c0 03 00 00 | 75 c0 03 00 bf 01 00 00 |\.......|u.......|
|00000f80| 36 c4 03 00 5b 03 00 00 | f6 c5 03 00 76 01 00 00 |6...[...|....v...|
|00000f90| 52 c9 03 00 91 00 00 00 | c9 ca 03 00 73 01 00 00 |R.......|....s...|
|00000fa0| 5b cb 03 00 46 02 00 00 | cf cc 03 00 db 02 00 00 |[...F...|........|
|00000fb0| 16 cf 03 00 d0 00 00 00 | f2 d1 03 00 9c 01 00 00 |........|........|
|00000fc0| c3 d2 03 00 03 02 00 00 | 60 d4 03 00 ea 00 00 00 |........|`.......|
|00000fd0| 64 d6 03 00 ea 00 00 00 | 4f d7 03 00 90 01 00 00 |d.......|O.......|
|00000fe0| 3a d8 03 00 f6 00 00 00 | cb d9 03 00 28 01 00 00 |:.......|....(...|
|00000ff0| c2 da 03 00 db 00 00 00 | eb db 03 00 88 01 00 00 |........|........|
|00001000| c7 dc 03 00 b5 00 00 00 | 50 de 03 00 cf 01 00 00 |........|P.......|
|00001010| 06 df 03 00 0c 01 00 00 | d6 e0 03 00 c1 01 00 00 |........|........|
|00001020| e3 e1 03 00 a3 01 00 00 | a5 e3 03 00 4c 01 00 00 |........|....L...|
|00001030| 49 e5 03 00 19 01 00 00 | 96 e6 03 00 56 01 00 00 |I.......|....V...|
|00001040| b0 e7 03 00 e8 02 00 00 | 07 e9 03 00 35 02 00 00 |........|....5...|
|00001050| f0 eb 03 00 e2 01 00 00 | 26 ee 03 00 5c 02 00 00 |........|&...\...|
|00001060| 09 f0 03 00 be 01 00 00 | 66 f2 03 00 e9 01 00 00 |........|f.......|
|00001070| 25 f4 03 00 96 01 00 00 | 0f f6 03 00 54 01 00 00 |%.......|....T...|
|00001080| a6 f7 03 00 9c 01 00 00 | fb f8 03 00 09 02 00 00 |........|........|
|00001090| 98 fa 03 00 a3 01 00 00 | a2 fc 03 00 a8 01 00 00 |........|........|
|000010a0| 46 fe 03 00 ae 01 00 00 | ef ff 03 00 08 01 00 00 |F.......|........|
|000010b0| 9e 01 04 00 8c 01 00 00 | a7 02 04 00 d1 01 00 00 |........|........|
|000010c0| 34 04 04 00 f2 00 00 00 | 06 06 04 00 d5 01 00 00 |4.......|........|
|000010d0| f9 06 04 00 bf 01 00 00 | cf 08 04 00 03 01 00 00 |........|........|
|000010e0| 8f 0a 04 00 77 02 00 00 | 93 0b 04 00 17 02 00 00 |....w...|........|
|000010f0| 0b 0e 04 00 e2 00 00 00 | 23 10 04 00 39 01 00 00 |........|#...9...|
|00001100| 06 11 04 00 81 01 00 00 | 40 12 04 00 94 01 00 00 |........|@.......|
|00001110| c2 13 04 00 61 01 00 00 | 57 15 04 00 71 01 00 00 |....a...|W...q...|
|00001120| b9 16 04 00 5e 01 00 00 | 2b 18 04 00 82 01 00 00 |....^...|+.......|
|00001130| 8a 19 04 00 54 01 00 00 | 0d 1b 04 00 79 01 00 00 |....T...|....y...|
|00001140| 62 1c 04 00 7f 01 00 00 | dc 1d 04 00 a8 01 00 00 |b.......|........|
|00001150| 5c 1f 04 00 86 01 00 00 | 05 21 04 00 9c 01 00 00 |\.......|.!......|
|00001160| 8c 22 04 00 a7 01 00 00 | 29 24 04 00 5b 01 00 00 |."......|)$..[...|
|00001170| d1 25 04 00 30 01 00 00 | 2d 27 04 00 60 01 00 00 |.%..0...|-'..`...|
|00001180| 5e 28 04 00 3f 01 00 00 | bf 29 04 00 56 01 00 00 |^(..?...|.)..V...|
|00001190| ff 2a 04 00 3b 01 00 00 | 56 2c 04 00 61 01 00 00 |.*..;...|V,..a...|
|000011a0| 92 2d 04 00 55 01 00 00 | f4 2e 04 00 2c 01 00 00 |.-..U...|....,...|
|000011b0| 4a 30 04 00 29 02 00 00 | 77 31 04 00 48 01 00 00 |J0..)...|w1..H...|
|000011c0| a1 33 04 00 47 01 00 00 | ea 34 04 00 0f 01 00 00 |.3..G...|.4......|
|000011d0| 32 36 04 00 d2 01 00 00 | 42 37 04 00 4e 01 00 00 |26......|B7..N...|
|000011e0| 15 39 04 00 2a 01 00 00 | 64 3a 04 00 35 01 00 00 |.9..*...|d:..5...|
|000011f0| 8f 3b 04 00 57 01 00 00 | c5 3c 04 00 2c 01 00 00 |.;..W...|.<..,...|
|00001200| 1d 3e 04 00 5e 01 00 00 | 4a 3f 04 00 41 01 00 00 |.>..^...|J?..A...|
|00001210| a9 40 04 00 60 01 00 00 | eb 41 04 00 48 01 00 00 |.@..`...|.A..H...|
|00001220| 4c 43 04 00 33 01 00 00 | 95 44 04 00 65 01 00 00 |LC..3...|.D..e...|
|00001230| c9 45 04 00 2c 02 00 00 | 2f 47 04 00 27 03 00 00 |.E..,...|/G..'...|
|00001240| 5c 49 04 00 13 01 00 00 | 84 4c 04 00 bd 02 00 00 |\I......|.L......|
|00001250| 98 4d 04 00 ac 00 00 00 | 56 50 04 00 e0 00 00 00 |.M......|VP......|
|00001260| 03 51 04 00 dc 00 00 00 | e4 51 04 00 cc 00 00 00 |.Q......|.Q......|
|00001270| c1 52 04 00 b6 00 00 00 | 8e 53 04 00 c6 00 00 00 |.R......|.S......|
|00001280| 45 54 04 00 cf 00 00 00 | 0c 55 04 00 c4 00 00 00 |ET......|.U......|
|00001290| dc 55 04 00 d4 00 00 00 | a1 56 04 00 e3 02 00 00 |.U......|.V......|
|000012a0| 76 57 04 00 bf 02 00 00 | 5a 5a 04 00 08 01 00 00 |vW......|ZZ......|
|000012b0| 1a 5d 04 00 96 00 00 00 | 23 5e 04 00 c5 00 00 00 |.]......|#^......|
|000012c0| ba 5e 04 00 c4 00 00 00 | 80 5f 04 00 7f 00 00 00 |.^......|._......|
|000012d0| 45 60 04 00 d3 02 00 00 | c5 60 04 00 dc 01 00 00 |E`......|.`......|
|000012e0| 99 63 04 00 dd 00 00 00 | 76 65 04 00 cd 00 00 00 |.c......|ve......|
|000012f0| 54 66 04 00 26 01 00 00 | 22 67 04 00 f0 00 00 00 |Tf..&...|"g......|
|00001300| 49 68 04 00 ef 00 00 00 | 3a 69 04 00 f2 00 00 00 |Ih......|:i......|
|00001310| 2a 6a 04 00 cd 00 00 00 | 1d 6b 04 00 6a 01 00 00 |*j......|.k..j...|
|00001320| eb 6b 04 00 02 01 00 00 | 56 6d 04 00 cd 00 00 00 |.k......|Vm......|
|00001330| 59 6e 04 00 2b 02 00 00 | 27 6f 04 00 f0 00 00 00 |Yn..+...|'o......|
|00001340| 53 71 04 00 2c 02 00 00 | 44 72 04 00 4a 02 00 00 |Sq..,...|Dr..J...|
|00001350| 71 74 04 00 dd 00 00 00 | bc 76 04 00 5c 03 00 00 |qt......|.v..\...|
|00001360| 9a 77 04 00 9b 01 00 00 | f7 7a 04 00 6c 02 00 00 |.w......|.z..l...|
|00001370| 93 7c 04 00 ea 01 00 00 | 00 7f 04 00 c5 02 00 00 |.|......|........|
|00001380| eb 80 04 00 cb 01 00 00 | b1 83 04 00 1a 01 00 00 |........|........|
|00001390| 7d 85 04 00 9b 01 00 00 | 98 86 04 00 6c 02 00 00 |}.......|....l...|
|000013a0| 34 88 04 00 c4 01 00 00 | a1 8a 04 00 78 01 00 00 |4.......|....x...|
|000013b0| 66 8c 04 00 c0 00 00 00 | df 8d 04 00 39 01 00 00 |f.......|....9...|
|000013c0| a0 8e 04 00 35 01 00 00 | da 8f 04 00 3f 02 00 00 |....5...|....?...|
|000013d0| 10 91 04 00 7b 01 00 00 | 50 93 04 00 dd 01 00 00 |....{...|P.......|
|000013e0| cc 94 04 00 12 01 00 00 | aa 96 04 00 e4 00 00 00 |........|........|
|000013f0| bd 97 04 00 a6 00 00 00 | a2 98 04 00 01 03 00 00 |........|........|
|00001400| 49 99 04 00 2e 02 00 00 | 4b 9c 04 00 1c 02 00 00 |I.......|K.......|
|00001410| 7a 9e 04 00 3e 02 00 00 | 97 a0 04 00 28 01 00 00 |z...>...|....(...|
|00001420| d6 a2 04 00 f3 01 00 00 | ff a3 04 00 2e 01 00 00 |........|........|
|00001430| f3 a5 04 00 a7 01 00 00 | 22 a7 04 00 86 00 00 00 |........|".......|
|00001440| ca a8 04 00 77 01 00 00 | 51 a9 04 00 c3 00 00 00 |....w...|Q.......|
|00001450| c9 aa 04 00 a5 00 00 00 | 8d ab 04 00 8d 00 00 00 |........|........|
|00001460| 33 ac 04 00 5d 02 00 00 | c1 ac 04 00 ed 00 00 00 |3...]...|........|
|00001470| 1f af 04 00 d4 01 00 00 | 0d b0 04 00 d8 00 00 00 |........|........|
|00001480| e2 b1 04 00 4e 03 00 00 | bb b2 04 00 4e 03 00 00 |....N...|....N...|
|00001490| 0a b6 04 00 4e 03 00 00 | 59 b9 04 00 4e 03 00 00 |....N...|Y...N...|
|000014a0| a8 bc 04 00 2d 02 00 00 | f7 bf 04 00 97 01 00 00 |....-...|........|
|000014b0| 25 c2 04 00 97 01 00 00 | bd c3 04 00 97 01 00 00 |%.......|........|
|000014c0| 55 c5 04 00 97 01 00 00 | ed c6 04 00 97 01 00 00 |U.......|........|
|000014d0| 85 c8 04 00 97 01 00 00 | 1d ca 04 00 97 01 00 00 |........|........|
|000014e0| b5 cb 04 00 97 01 00 00 | 4d cd 04 00 97 01 00 00 |........|M.......|
|000014f0| e5 ce 04 00 97 01 00 00 | 7d d0 04 00 97 01 00 00 |........|}.......|
|00001500| 15 d2 04 00 e1 00 00 00 | ad d3 04 00 06 01 00 00 |........|........|
|00001510| 8f d4 04 00 30 02 00 00 | 96 d5 04 00 92 01 00 00 |....0...|........|
|00001520| c7 d7 04 00 94 00 00 00 | 5a d9 04 00 0f 01 00 00 |........|Z.......|
|00001530| ef d9 04 00 33 02 00 00 | ff da 04 00 4b 02 00 00 |....3...|....K...|
|00001540| 33 dd 04 00 4e 03 00 00 | 7f df 04 00 4e 03 00 00 |3...N...|....N...|
|00001550| ce e2 04 00 4e 03 00 00 | 1d e6 04 00 77 03 00 00 |....N...|....w...|
|00001560| 6c e9 04 00 12 01 00 00 | e4 ec 04 00 33 02 00 00 |l.......|....3...|
|00001570| f7 ed 04 00 26 03 00 00 | 2b f0 04 00 0d 01 00 00 |....&...|+.......|
|00001580| 52 f3 04 00 d7 00 00 00 | 60 f4 04 00 21 01 00 00 |R.......|`...!...|
|00001590| 38 f5 04 00 6c 01 00 00 | 5a f6 04 00 ca 00 00 00 |8...l...|Z.......|
|000015a0| c7 f7 04 00 9b 01 00 00 | 92 f8 04 00 58 01 00 00 |........|....X...|
|000015b0| 2e fa 04 00 cc 00 00 00 | 87 fb 04 00 80 03 00 00 |........|........|
|000015c0| 54 fc 04 00 d0 00 00 00 | d5 ff 04 00 11 02 00 00 |T.......|........|
|000015d0| a6 00 05 00 d4 00 00 00 | b8 02 05 00 02 01 00 00 |........|........|
|000015e0| 8d 03 05 00 1f 02 00 00 | 90 04 05 00 be 01 00 00 |........|........|
|000015f0| b0 06 05 00 b2 01 00 00 | 6f 08 05 00 14 02 00 00 |........|o.......|
|00001600| 22 0a 05 00 29 01 00 00 | 37 0c 05 00 39 02 00 00 |"...)...|7...9...|
|00001610| 61 0d 05 00 29 01 00 00 | 9b 0f 05 00 25 01 00 00 |a...)...|....%...|
|00001620| c5 10 05 00 d8 00 00 00 | eb 11 05 00 b8 01 00 00 |........|........|
|00001630| c4 12 05 00 0f 01 00 00 | 7d 14 05 00 4c 03 00 00 |........|}...L...|
|00001640| 8d 15 05 00 c9 00 00 00 | da 18 05 00 29 01 00 00 |........|....)...|
|00001650| a4 19 05 00 cc 00 00 00 | ce 1a 05 00 a5 01 00 00 |........|........|
|00001660| 9b 1b 05 00 ba 00 00 00 | 41 1d 05 00 0a 02 00 00 |........|A.......|
|00001670| fc 1d 05 00 c7 00 00 00 | 07 20 05 00 5f 02 00 00 |........|. .._...|
|00001680| cf 20 05 00 ef 00 00 00 | 2f 23 05 00 21 01 00 00 |. ......|/#..!...|
|00001690| 1f 24 05 00 4e 03 00 00 | 41 25 05 00 17 01 00 00 |.$..N...|A%......|
|000016a0| 90 28 05 00 e1 00 00 00 | a8 29 05 00 3c 01 00 00 |.(......|.)..<...|
|000016b0| 8a 2a 05 00 0e 03 00 00 | c7 2b 05 00 8f 02 00 00 |.*......|.+......|
|000016c0| d6 2e 05 00 a5 02 00 00 | 66 31 05 00 b0 02 00 00 |........|f1......|
|000016d0| 0c 34 05 00 c9 00 00 00 | bd 36 05 00 33 01 00 00 |.4......|.6..3...|
|000016e0| 87 37 05 00 0b 04 00 00 | bb 38 05 00 c7 01 00 00 |.7......|.8......|
|000016f0| c7 3c 05 00 67 02 00 00 | 8f 3e 05 00 2e 01 00 00 |.<..g...|.>......|
|00001700| f7 40 05 00 f7 00 00 00 | 26 42 05 00 3c 01 00 00 |.@......|&B..<...|
|00001710| 1e 43 05 00 c5 02 00 00 | 5b 44 05 00 dc 01 00 00 |.C......|[D......|
|00001720| 21 47 05 00 8e 01 00 00 | fe 48 05 00 f6 00 00 00 |!G......|.H......|
|00001730| 8d 4a 05 00 db 00 00 00 | 84 4b 05 00 30 02 00 00 |.J......|.K..0...|
|00001740| 60 4c 05 00 94 01 00 00 | 91 4e 05 00 61 02 00 00 |`L......|.N..a...|
|00001750| 26 50 05 00 69 02 00 00 | 88 52 05 00 a5 01 00 00 |&P..i...|.R......|
|00001760| f2 54 05 00 69 02 00 00 | 98 56 05 00 35 02 00 00 |.T..i...|.V..5...|
|00001770| 02 59 05 00 5e 01 00 00 | 38 5b 05 00 01 03 00 00 |.Y..^...|8[......|
|00001780| 97 5c 05 00 0b 02 00 00 | 99 5f 05 00 fd 02 00 00 |.\......|._......|
|00001790| a5 61 05 00 5d 01 00 00 | a3 64 05 00 b5 02 00 00 |.a..]...|.d......|
|000017a0| 01 66 05 00 b5 02 00 00 | b7 68 05 00 b5 02 00 00 |.f......|.h......|
|000017b0| 6d 6b 05 00 04 01 00 00 | 23 6e 05 00 fa 00 00 00 |mk......|#n......|
|000017c0| 28 6f 05 00 2c 01 00 00 | 23 70 05 00 23 01 00 00 |(o..,...|#p..#...|
|000017d0| 50 71 05 00 c1 00 00 00 | 74 72 05 00 14 01 00 00 |Pq......|tr......|
|000017e0| 36 73 05 00 19 01 00 00 | 4b 74 05 00 8c 00 00 00 |6s......|Kt......|
|000017f0| 65 75 05 00 c0 03 00 00 | f2 75 05 00 07 01 00 00 |eu......|.u......|
|00001800| b3 79 05 00 ab 00 00 00 | bb 7a 05 00 c0 01 00 00 |.y......|.z......|
|00001810| 67 7b 05 00 92 04 00 00 | 28 7d 05 00 07 01 00 00 |g{......|(}......|
|00001820| bb 81 05 00 f2 00 00 00 | c3 82 05 00 b8 00 00 00 |........|........|
|00001830| b6 83 05 00 30 01 00 00 | 6f 84 05 00 d9 00 00 00 |....0...|o.......|
|00001840| a0 85 05 00 c7 00 00 00 | 7a 86 05 00 61 02 00 00 |........|z...a...|
|00001850| 42 87 05 00 66 02 00 00 | a4 89 05 00 c5 01 00 00 |B...f...|........|
|00001860| 0b 8c 05 00 69 02 00 00 | d1 8d 05 00 e4 02 00 00 |....i...|........|
|00001870| 3b 90 05 00 c7 02 00 00 | 20 93 05 00 f7 02 00 00 |;.......| .......|
|00001880| e8 95 05 00 20 02 00 00 | e0 98 05 00 25 02 00 00 |.... ...|....%...|
|00001890| 01 9b 05 00 7a 01 00 00 | 27 9d 05 00 72 01 00 00 |....z...|'...r...|
|000018a0| a2 9e 05 00 de 00 00 00 | 15 a0 05 00 4e 03 00 00 |........|....N...|
|000018b0| f4 a0 05 00 4e 03 00 00 | 43 a4 05 00 01 00 00 00 |....N...|C.......|
|000018c0| c3 00 00 00 fa 00 00 00 | 00 00 00 00 57 01 00 00 |........|....W...|
|000018d0| 2b 00 00 00 26 01 00 00 | e5 00 00 00 62 01 00 00 |+...&...|....b...|
|000018e0| 49 01 00 00 46 00 00 00 | 1e 01 00 00 00 00 00 00 |I...F...|........|
|000018f0| 45 01 00 00 47 01 00 00 | 00 00 00 00 00 00 00 00 |E...G...|........|
|00001900| 00 00 00 00 00 00 00 00 | 7f 01 00 00 1a 01 00 00 |........|........|
|00001910| 00 00 00 00 0b 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001920| 40 01 00 00 00 00 00 00 | 00 00 00 00 54 00 00 00 |@.......|....T...|
|00001930| 83 00 00 00 24 01 00 00 | 00 00 00 00 2c 00 00 00 |....$...|....,...|
|00001940| 71 01 00 00 00 00 00 00 | c5 00 00 00 11 00 00 00 |q.......|........|
|00001950| 00 00 00 00 7a 01 00 00 | 00 00 00 00 9a 00 00 00 |....z...|........|
|00001960| a7 00 00 00 f0 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001970| 00 00 00 00 1a 00 00 00 | 65 01 00 00 00 00 00 00 |........|e.......|
|00001980| 2d 01 00 00 b1 00 00 00 | 5c 01 00 00 1f 01 00 00 |-.......|\.......|
|00001990| 00 00 00 00 a1 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019a0| 17 01 00 00 94 00 00 00 | 4c 01 00 00 78 01 00 00 |........|L...x...|
|000019b0| 08 00 00 00 51 00 00 00 | 39 00 00 00 33 01 00 00 |....Q...|9...3...|
|000019c0| ff 00 00 00 22 01 00 00 | 6a 01 00 00 8d 00 00 00 |...."...|j.......|
|000019d0| 75 00 00 00 00 00 00 00 | 3d 00 00 00 3d 01 00 00 |u.......|=...=...|
|000019e0| a4 00 00 00 77 00 00 00 | 00 00 00 00 76 01 00 00 |....w...|....v...|
|000019f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 58 00 00 00 |........|....X...|
|00001a00| 99 00 00 00 ba 00 00 00 | 00 00 00 00 f1 00 00 00 |........|........|
|00001a10| 31 00 00 00 5e 01 00 00 | e8 00 00 00 4d 00 00 00 |1...^...|....M...|
|00001a20| 81 00 00 00 00 00 00 00 | 9b 00 00 00 ca 00 00 00 |........|........|
|00001a30| 4b 01 00 00 00 00 00 00 | 7d 01 00 00 63 00 00 00 |K.......|}...c...|
|00001a40| 02 00 00 00 d6 00 00 00 | 65 00 00 00 5e 00 00 00 |........|e...^...|
|00001a50| 00 00 00 00 ea 00 00 00 | 00 00 00 00 60 01 00 00 |........|....`...|
|00001a60| b0 00 00 00 00 00 00 00 | 48 01 00 00 00 00 00 00 |........|H.......|
|00001a70| 17 00 00 00 62 00 00 00 | 00 00 00 00 7b 01 00 00 |....b...|....{...|
|00001a80| 23 01 00 00 3c 00 00 00 | 00 00 00 00 f8 00 00 00 |#...<...|........|
|00001a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 6e 00 00 00 |........|....n...|
|00001aa0| 16 01 00 00 00 00 00 00 | a0 00 00 00 00 00 00 00 |........|........|
|00001ab0| 27 00 00 00 21 00 00 00 | 64 00 00 00 07 00 00 00 |'...!...|d.......|
|00001ac0| 43 00 00 00 28 01 00 00 | b5 00 00 00 5f 00 00 00 |C...(...|...._...|
|00001ad0| 1c 00 00 00 00 00 00 00 | f6 00 00 00 58 01 00 00 |........|....X...|
|00001ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 04 01 00 00 |........|........|
|00001af0| 00 00 00 00 83 01 00 00 | 50 01 00 00 3b 00 00 00 |........|P...;...|
|00001b00| 00 00 00 00 d9 00 00 00 | 1b 01 00 00 0d 00 00 00 |........|........|
|00001b10| 00 00 00 00 00 00 00 00 | 87 01 00 00 69 00 00 00 |........|....i...|
|00001b20| 00 00 00 00 95 00 00 00 | 9d 00 00 00 00 00 00 00 |........|........|
|00001b30| be 00 00 00 00 00 00 00 | 59 00 00 00 44 01 00 00 |........|Y...D...|
|00001b40| 34 01 00 00 33 00 00 00 | 4a 00 00 00 75 01 00 00 |4...3...|J...u...|
|00001b50| 02 01 00 00 a6 00 00 00 | 00 00 00 00 b3 00 00 00 |........|........|
|00001b60| 00 00 00 00 93 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b70| 56 01 00 00 00 00 00 00 | c2 00 00 00 42 00 00 00 |V.......|....B...|
|00001b80| db 00 00 00 37 01 00 00 | 00 00 00 00 05 01 00 00 |....7...|........|
|00001b90| 4f 01 00 00 6f 01 00 00 | 29 01 00 00 2b 01 00 00 |O...o...|)...+...|
|00001ba0| 2d 00 00 00 c9 00 00 00 | 00 00 00 00 55 00 00 00 |-.......|....U...|
|00001bb0| f2 00 00 00 00 00 00 00 | 8f 00 00 00 0f 01 00 00 |........|........|
|00001bc0| 52 00 00 00 98 00 00 00 | 38 01 00 00 8b 00 00 00 |R.......|8.......|
|00001bd0| f3 00 00 00 23 00 00 00 | e7 00 00 00 00 00 00 00 |....#...|........|
|00001be0| 19 01 00 00 06 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bf0| b9 00 00 00 a2 00 00 00 | 39 01 00 00 10 00 00 00 |........|9.......|
|00001c00| e0 00 00 00 7a 00 00 00 | 2f 01 00 00 00 00 00 00 |....z...|/.......|
|00001c10| e9 00 00 00 0e 01 00 00 | 9f 00 00 00 18 00 00 00 |........|........|
|00001c20| 3f 01 00 00 0d 01 00 00 | 00 00 00 00 c7 00 00 00 |?.......|........|
|00001c30| ae 00 00 00 00 00 00 00 | 5b 00 00 00 eb 00 00 00 |........|[.......|
|00001c40| 8e 00 00 00 c8 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c50| 78 00 00 00 60 00 00 00 | 70 00 00 00 7f 00 00 00 |x...`...|p.......|
|00001c60| 00 00 00 00 cd 00 00 00 | 76 00 00 00 47 00 00 00 |........|v...G...|
|00001c70| 35 01 00 00 5c 00 00 00 | 00 00 00 00 6b 01 00 00 |5...\...|....k...|
|00001c80| 32 01 00 00 45 00 00 00 | 81 01 00 00 00 00 00 00 |2...E...|........|
|00001c90| cf 00 00 00 31 01 00 00 | 38 00 00 00 fd 00 00 00 |....1...|8.......|
|00001ca0| 34 00 00 00 00 00 00 00 | 22 00 00 00 73 00 00 00 |4.......|"...s...|
|00001cb0| 54 01 00 00 41 01 00 00 | 1e 00 00 00 09 00 00 00 |T...A...|........|
|00001cc0| 13 01 00 00 ab 00 00 00 | 2a 00 00 00 8a 01 00 00 |........|*.......|
|00001cd0| b8 00 00 00 67 00 00 00 | 32 00 00 00 b4 00 00 00 |....g...|2.......|
|00001ce0| 00 00 00 00 3e 00 00 00 | 09 01 00 00 fe 00 00 00 |....>...|........|
|00001cf0| cb 00 00 00 00 00 00 00 | 36 00 00 00 e6 00 00 00 |........|6.......|
|00001d00| 59 01 00 00 7e 00 00 00 | 21 01 00 00 50 00 00 00 |Y...~...|!...P...|
|00001d10| 00 00 00 00 68 00 00 00 | 03 00 00 00 5d 00 00 00 |....h...|....]...|
|00001d20| 6a 00 00 00 03 01 00 00 | ad 00 00 00 0f 00 00 00 |j.......|........|
|00001d30| 97 00 00 00 00 00 00 00 | 5f 01 00 00 20 00 00 00 |........|_... ...|
|00001d40| 5a 00 00 00 c6 00 00 00 | 57 00 00 00 20 01 00 00 |Z.......|W... ...|
|00001d50| 86 00 00 00 00 00 00 00 | 30 00 00 00 89 01 00 00 |........|0.......|
|00001d60| 00 00 00 00 00 00 00 00 | 7e 01 00 00 00 00 00 00 |........|~.......|
|00001d70| 1d 01 00 00 00 00 00 00 | 88 01 00 00 df 00 00 00 |........|........|
|00001d80| ef 00 00 00 55 01 00 00 | 00 00 00 00 00 00 00 00 |....U...|........|
|00001d90| 0a 00 00 00 d1 00 00 00 | bf 00 00 00 1f 00 00 00 |........|........|
|00001da0| 85 00 00 00 25 01 00 00 | 00 00 00 00 72 01 00 00 |....%...|....r...|
|00001db0| 00 00 00 00 12 00 00 00 | 42 01 00 00 e4 00 00 00 |........|B.......|
|00001dc0| 1c 01 00 00 92 00 00 00 | 00 00 00 00 d7 00 00 00 |........|........|
|00001dd0| 66 00 00 00 6c 00 00 00 | 35 00 00 00 d8 00 00 00 |f...l...|5.......|
|00001de0| c1 00 00 00 00 00 00 00 | 40 00 00 00 dd 00 00 00 |........|@.......|
|00001df0| 37 00 00 00 00 00 00 00 | 4e 01 00 00 18 01 00 00 |7.......|N.......|
|00001e00| 08 01 00 00 e3 00 00 00 | 00 00 00 00 82 00 00 00 |........|........|
|00001e10| 3e 01 00 00 d2 00 00 00 | 00 00 00 00 84 01 00 00 |>.......|........|
|00001e20| f9 00 00 00 2e 01 00 00 | 2c 01 00 00 aa 00 00 00 |........|,.......|
|00001e30| 00 00 00 00 d4 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e40| c4 00 00 00 00 00 00 00 | 91 00 00 00 53 00 00 00 |........|....S...|
|00001e50| 8c 00 00 00 89 00 00 00 | 63 01 00 00 49 00 00 00 |........|c...I...|
|00001e60| a9 00 00 00 3f 00 00 00 | 00 00 00 00 e2 00 00 00 |....?...|........|
|00001e70| 00 00 00 00 4c 00 00 00 | a5 00 00 00 53 01 00 00 |....L...|....S...|
|00001e80| 00 00 00 00 0c 00 00 00 | 00 00 00 00 67 01 00 00 |........|....g...|
|00001e90| 3a 01 00 00 00 00 00 00 | 4d 01 00 00 07 01 00 00 |:.......|M.......|
|00001ea0| de 00 00 00 00 00 00 00 | 87 00 00 00 00 00 00 00 |........|........|
|00001eb0| 9e 00 00 00 82 01 00 00 | 6e 01 00 00 b2 00 00 00 |........|n.......|
|00001ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 72 00 00 00 |........|....r...|
|00001ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 15 01 00 00 |........|........|
|00001ee0| 2f 00 00 00 70 01 00 00 | 28 00 00 00 10 01 00 00 |/...p...|(.......|
|00001ef0| 6f 00 00 00 f5 00 00 00 | 64 01 00 00 0b 00 00 00 |o.......|d.......|
|00001f00| 6c 01 00 00 b6 00 00 00 | e1 00 00 00 00 00 00 00 |l.......|........|
|00001f10| 00 00 00 00 14 01 00 00 | 6b 00 00 00 00 00 00 00 |........|k.......|
|00001f20| bd 00 00 00 4f 00 00 00 | f4 00 00 00 3b 01 00 00 |....O...|....;...|
|00001f30| 00 00 00 00 00 00 00 00 | fb 00 00 00 5b 01 00 00 |........|....[...|
|00001f40| 00 00 00 00 36 01 00 00 | a8 00 00 00 04 00 00 00 |....6...|........|
|00001f50| 79 01 00 00 3a 00 00 00 | 44 00 00 00 00 00 00 00 |y...:...|D.......|
|00001f60| 24 00 00 00 4e 00 00 00 | 79 00 00 00 00 00 00 00 |$...N...|y.......|
|00001f70| bc 00 00 00 05 00 00 00 | cc 00 00 00 80 01 00 00 |........|........|
|00001f80| ee 00 00 00 00 00 00 00 | 43 01 00 00 0a 01 00 00 |........|C.......|
|00001f90| 00 00 00 00 30 01 00 00 | 46 01 00 00 80 00 00 00 |....0...|F.......|
|00001fa0| ed 00 00 00 00 00 00 00 | 74 00 00 00 00 00 00 00 |........|t.......|
|00001fb0| 7d 00 00 00 77 01 00 00 | 00 00 00 00 5d 01 00 00 |}...w...|....]...|
|00001fc0| 13 00 00 00 66 01 00 00 | 00 00 00 00 00 00 00 00 |....f...|........|
|00001fd0| 00 00 00 00 d3 00 00 00 | c0 00 00 00 56 00 00 00 |........|....V...|
|00001fe0| 51 01 00 00 4b 00 00 00 | 00 00 00 00 2a 01 00 00 |Q...K...|....*...|
|00001ff0| 00 00 00 00 06 00 00 00 | 61 00 00 00 ec 00 00 00 |........|a.......|
|00002000| 90 00 00 00 1d 00 00 00 | 00 00 00 00 7b 00 00 00 |........|....{...|
|00002010| 00 00 00 00 9c 00 00 00 | 96 00 00 00 48 00 00 00 |........|....H...|
|00002020| 71 00 00 00 a3 00 00 00 | 27 01 00 00 00 00 00 00 |q.......|'.......|
|00002030| 88 00 00 00 00 00 00 00 | 2e 00 00 00 52 01 00 00 |........|....R...|
|00002040| 00 00 00 00 00 00 00 00 | 86 01 00 00 61 01 00 00 |........|....a...|
|00002050| 00 00 00 00 01 01 00 00 | 00 00 00 00 26 00 00 00 |........|....&...|
|00002060| 19 00 00 00 29 00 00 00 | 00 01 00 00 11 01 00 00 |....)...|........|
|00002070| 74 01 00 00 85 01 00 00 | 7c 01 00 00 d5 00 00 00 |t.......||.......|
|00002080| d0 00 00 00 00 00 00 00 | dc 00 00 00 00 00 00 00 |........|........|
|00002090| 6d 00 00 00 00 00 00 00 | 7c 00 00 00 5a 01 00 00 |m.......||...Z...|
|000020a0| ac 00 00 00 25 00 00 00 | 1b 00 00 00 00 00 00 00 |....%...|........|
|000020b0| da 00 00 00 68 01 00 00 | 00 00 00 00 00 00 00 00 |....h...|........|
|000020c0| 6d 01 00 00 8a 00 00 00 | b7 00 00 00 73 01 00 00 |m.......|....s...|
|000020d0| 00 00 00 00 00 00 00 00 | 15 00 00 00 00 00 00 00 |........|........|
|000020e0| 00 00 00 00 16 00 00 00 | 69 01 00 00 0c 01 00 00 |........|i.......|
|000020f0| bb 00 00 00 41 00 00 00 | 0e 00 00 00 00 00 00 00 |....A...|........|
|00002100| fc 00 00 00 4a 01 00 00 | 84 00 00 00 ce 00 00 00 |....J...|........|
|00002110| 12 01 00 00 3c 01 00 00 | 00 00 00 00 af 00 00 00 |....<...|........|
|00002120| 00 00 00 00 00 00 00 00 | f7 00 00 00 14 00 00 00 |........|........|
|00002130| 00 40 46 55 4e 43 54 49 | 4f 4e 3d 41 42 53 0a 40 |.@FUNCTI|ON=ABS.@|
|00002140| 53 59 4e 54 41 58 3d 41 | 42 53 28 62 31 29 0a 40 |SYNTAX=A|BS(b1).@|
|00002150| 44 45 53 43 52 49 50 54 | 49 4f 4e 3d 41 42 53 20 |DESCRIPT|ION=ABS |
|00002160| 69 6d 70 6c 65 6d 65 6e | 74 73 20 74 68 65 20 41 |implemen|ts the A|
|00002170| 62 73 6f 6c 75 74 65 20 | 56 61 6c 75 65 20 66 75 |bsolute |Value fu|
|00002180| 6e 63 74 69 6f 6e 3a 20 | 20 74 68 65 20 72 65 73 |nction: | the res|
|00002190| 75 6c 74 20 69 73 20 74 | 6f 20 64 72 6f 70 20 74 |ult is t|o drop t|
|000021a0| 68 65 20 6e 65 67 61 74 | 69 76 65 20 73 69 67 6e |he negat|ive sign|
|000021b0| 20 28 69 66 20 70 72 65 | 73 65 6e 74 29 2e 20 20 | (if pre|sent).  |
|000021c0| 54 68 69 73 20 63 61 6e | 20 62 65 20 64 6f 6e 65 |This can| be done|
|000021d0| 20 66 6f 72 20 69 6e 74 | 65 67 65 72 73 20 61 6e | for int|egers an|
|000021e0| 64 20 66 6c 6f 61 74 69 | 6e 67 20 70 6f 69 6e 74 |d floati|ng point|
|000021f0| 20 6e 75 6d 62 65 72 73 | 2e 0a 0a 2a 20 54 68 69 | numbers|...* Thi|
|00002200| 73 20 66 75 6e 63 74 69 | 6f 6e 20 69 73 20 45 78 |s functi|on is Ex|
|00002210| 63 65 6c 20 63 6f 6d 70 | 61 74 69 62 6c 65 2e 0a |cel comp|atible..|
|00002220| 0a 40 45 58 41 4d 50 4c | 45 53 3d 0a 41 42 53 28 |.@EXAMPL|ES=.ABS(|
|00002230| 37 29 20 65 71 75 61 6c | 73 20 37 2e 0a 41 42 53 |7) equal|s 7..ABS|
|00002240| 28 2d 33 2e 31 34 29 20 | 65 71 75 61 6c 73 20 33 |(-3.14) |equals 3|
|00002250| 2e 31 34 2e 0a 0a 40 53 | 45 45 41 4c 53 4f 3d 43 |.14...@S|EEALSO=C|
|00002260| 45 49 4c 2c 20 43 45 49 | 4c 49 4e 47 2c 20 46 4c |EIL, CEI|LING, FL|
|00002270| 4f 4f 52 2c 20 49 4e 54 | 2c 20 4d 4f 44 00 40 46 |OOR, INT|, MOD.@F|
|00002280| 55 4e 43 54 49 4f 4e 3d | 41 43 43 52 49 4e 54 0a |UNCTION=|ACCRINT.|
|00002290| 40 53 59 4e 54 41 58 3d | 41 43 43 52 49 4e 54 28 |@SYNTAX=|ACCRINT(|
|000022a0| 69 73 73 75 65 2c 66 69 | 72 73 74 5f 69 6e 74 65 |issue,fi|rst_inte|
|000022b0| 72 65 73 74 2c 73 65 74 | 74 6c 65 6d 65 6e 74 2c |rest,set|tlement,|
|000022c0| 72 61 74 65 2c 70 61 72 | 2c 66 72 65 71 75 65 6e |rate,par|,frequen|
|000022d0| 63 79 5b 2c 62 61 73 69 | 73 5d 29 0a 40 44 45 53 |cy[,basi|s]).@DES|
|000022e0| 43 52 49 50 54 49 4f 4e | 3d 41 43 43 52 49 4e 54 |CRIPTION|=ACCRINT|
|000022f0| 20 63 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 | calcula|tes the |
|00002300| 61 63 63 72 75 65 64 20 | 69 6e 74 65 72 65 73 74 |accrued |interest|
|00002310| 20 66 6f 72 20 61 20 73 | 65 63 75 72 69 74 79 20 | for a s|ecurity |
|00002320| 74 68 61 74 20 70 61 79 | 73 20 70 65 72 69 6f 64 |that pay|s period|
|00002330| 69 63 20 69 6e 74 65 72 | 65 73 74 2e 0a 0a 40 69 |ic inter|est...@i|
|00002340| 73 73 75 65 20 69 73 20 | 74 68 65 20 69 73 73 75 |ssue is |the issu|
|00002350| 65 20 64 61 74 65 20 6f | 66 20 74 68 65 20 73 65 |e date o|f the se|
|00002360| 63 75 72 69 74 79 2e 20 | 20 40 66 69 72 73 74 5f |curity. | @first_|
|00002370| 69 6e 74 65 72 65 73 74 | 20 69 73 20 74 68 65 20 |interest| is the |
|00002380| 66 69 72 73 74 20 69 6e | 74 65 72 65 73 74 20 64 |first in|terest d|
|00002390| 61 74 65 20 6f 66 20 74 | 68 65 20 73 65 63 75 72 |ate of t|he secur|
|000023a0| 69 74 79 2e 20 20 40 73 | 65 74 74 6c 65 6d 65 6e |ity.  @s|ettlemen|
|000023b0| 74 20 69 73 20 74 68 65 | 20 73 65 74 74 6c 65 6d |t is the| settlem|
|000023c0| 65 6e 74 20 64 61 74 65 | 20 6f 66 20 74 68 65 20 |ent date| of the |
|000023d0| 73 65 63 75 72 69 74 79 | 2e 20 20 54 68 65 20 73 |security|.  The s|
|000023e0| 65 74 74 6c 65 6d 65 6e | 74 20 64 61 74 65 20 69 |ettlemen|t date i|
|000023f0| 73 20 61 6c 77 61 79 73 | 20 61 66 74 65 72 20 74 |s always| after t|
|00002400| 68 65 20 69 73 73 75 65 | 20 64 61 74 65 20 28 74 |he issue| date (t|
|00002410| 68 65 20 64 61 74 65 20 | 77 68 65 6e 20 74 68 65 |he date |when the|
|00002420| 20 73 65 63 75 72 69 74 | 79 20 69 73 20 62 6f 75 | securit|y is bou|
|00002430| 67 68 74 29 2e 20 40 72 | 61 74 65 20 69 73 20 74 |ght). @r|ate is t|
|00002440| 68 65 20 61 6e 6e 75 61 | 6c 20 72 61 74 65 20 6f |he annua|l rate o|
|00002450| 66 20 74 68 65 20 73 65 | 63 75 72 69 74 79 20 61 |f the se|curity a|
|00002460| 6e 64 20 40 70 61 72 20 | 69 73 20 74 68 65 20 70 |nd @par |is the p|
|00002470| 61 72 20 76 61 6c 75 65 | 20 6f 66 20 74 68 65 20 |ar value| of the |
|00002480| 73 65 63 75 72 69 74 79 | 2e 20 40 66 72 65 71 75 |security|. @frequ|
|00002490| 65 6e 63 79 20 69 73 20 | 74 68 65 20 6e 75 6d 62 |ency is |the numb|
|000024a0| 65 72 20 6f 66 20 63 6f | 75 70 6f 6e 20 70 61 79 |er of co|upon pay|
|000024b0| 6d 65 6e 74 73 20 70 65 | 72 20 79 65 61 72 2e 0a |ments pe|r year..|
|000024c0| 0a 41 6c 6c 6f 77 65 64 | 20 66 72 65 71 75 65 6e |.Allowed| frequen|
|000024d0| 63 69 65 73 20 61 72 65 | 3a 0a 20 20 31 20 3d 20 |cies are|:.  1 = |
|000024e0| 61 6e 6e 75 61 6c 2c 0a | 20 20 32 20 3d 20 73 65 |annual,.|  2 = se|
|000024f0| 6d 69 2c 0a 20 20 34 20 | 3d 20 71 75 61 72 74 65 |mi,.  4 |= quarte|
|00002500| 72 6c 79 2e 0a 0a 40 62 | 61 73 69 73 20 69 73 20 |rly...@b|asis is |
|00002510| 74 68 65 20 74 79 70 65 | 20 6f 66 20 64 61 79 20 |the type| of day |
|00002520| 63 6f 75 6e 74 69 6e 67 | 20 73 79 73 74 65 6d 20 |counting| system |
|00002530| 79 6f 75 20 77 61 6e 74 | 20 74 6f 20 75 73 65 3a |you want| to use:|
|00002540| 0a 0a 20 20 30 20 20 55 | 53 20 33 30 2f 33 36 30 |..  0  U|S 30/360|
|00002550| 0a 20 20 31 20 20 61 63 | 74 75 61 6c 20 64 61 79 |.  1  ac|tual day|
|00002560| 73 2f 61 63 74 75 61 6c | 20 64 61 79 73 0a 20 20 |s/actual| days.  |
|00002570| 32 20 20 61 63 74 75 61 | 6c 20 64 61 79 73 2f 33 |2  actua|l days/3|
|00002580| 36 30 0a 20 20 33 20 20 | 61 63 74 75 61 6c 20 64 |60.  3  |actual d|
|00002590| 61 79 73 2f 33 36 35 0a | 20 20 34 20 20 45 75 72 |ays/365.|  4  Eur|
|000025a0| 6f 70 65 61 6e 20 33 30 | 2f 33 36 30 0a 0a 2a 20 |opean 30|/360..* |
|000025b0| 49 66 20 40 69 73 73 75 | 65 20 64 61 74 65 2c 20 |If @issu|e date, |
|000025c0| 40 66 69 72 73 74 5f 69 | 6e 74 65 72 65 73 74 20 |@first_i|nterest |
|000025d0| 64 61 74 65 2c 20 6f 72 | 20 40 73 65 74 74 6c 65 |date, or| @settle|
|000025e0| 6d 65 6e 74 20 64 61 74 | 65 20 69 73 20 6e 6f 74 |ment dat|e is not|
|000025f0| 20 76 61 6c 69 64 2c 20 | 41 43 43 52 49 4e 54 20 | valid, |ACCRINT |
|00002600| 72 65 74 75 72 6e 73 20 | 23 4e 55 4d 21 20 65 72 |returns |#NUM! er|
|00002610| 72 6f 72 2e 0a 2a 20 54 | 68 65 20 64 61 74 65 73 |ror..* T|he dates|
|00002620| 20 6d 75 73 74 20 62 65 | 20 40 69 73 73 75 65 20 | must be| @issue |
|00002630| 3c 20 40 66 69 72 73 74 | 5f 69 6e 74 65 72 65 73 |< @first|_interes|
|00002640| 74 20 3c 20 40 73 65 74 | 74 6c 65 6d 65 6e 74 2c |t < @set|tlement,|
|00002650| 20 6f 72 20 41 43 43 52 | 49 4e 54 20 72 65 74 75 | or ACCR|INT retu|
|00002660| 72 6e 73 20 23 4e 55 4d | 21 20 65 72 72 6f 72 2e |rns #NUM|! error.|
|00002670| 0a 2a 20 49 66 20 40 72 | 61 74 65 20 3c 3d 20 30 |.* If @r|ate <= 0|
|00002680| 20 6f 72 20 40 70 61 72 | 20 3c 3d 20 30 20 2c 20 | or @par| <= 0 , |
|00002690| 41 43 43 52 49 4e 54 20 | 72 65 74 75 72 6e 73 20 |ACCRINT |returns |
|000026a0| 23 4e 55 4d 21 20 65 72 | 72 6f 72 2e 0a 2a 20 49 |#NUM! er|ror..* I|
|000026b0| 66 20 40 62 61 73 69 73 | 20 69 73 20 6f 6d 69 74 |f @basis| is omit|
|000026c0| 74 65 64 2c 20 55 53 20 | 33 30 2f 33 36 30 20 69 |ted, US |30/360 i|
|000026d0| 73 20 61 70 70 6c 69 65 | 64 2e 0a 2a 20 49 66 20 |s applie|d..* If |
|000026e0| 40 62 61 73 69 73 20 3c | 20 30 20 6f 72 20 40 62 |@basis <| 0 or @b|
|000026f0| 61 73 69 73 20 3e 20 34 | 2c 20 41 43 43 52 49 4e |asis > 4|, ACCRIN|
|00002700| 54 20 72 65 74 75 72 6e | 73 20 23 4e 55 4d 21 20 |T return|s #NUM! |
|00002710| 65 72 72 6f 72 2e 0a 2a | 20 49 66 20 40 69 73 73 |error..*| If @iss|
|00002720| 75 65 20 64 61 74 65 20 | 69 73 20 61 66 74 65 72 |ue date |is after|
|00002730| 20 40 73 65 74 74 6c 65 | 6d 65 6e 74 20 64 61 74 | @settle|ment dat|
|00002740| 65 20 6f 72 20 74 68 65 | 79 20 61 72 65 20 74 68 |e or the|y are th|
|00002750| 65 20 73 61 6d 65 2c 20 | 41 43 43 52 49 4e 54 20 |e same, |ACCRINT |
|00002760| 72 65 74 75 72 6e 73 20 | 23 4e 55 4d 21 20 65 72 |returns |#NUM! er|
|00002770| 72 6f 72 2e 0a 0a 40 45 | 58 41 4d 50 4c 45 53 3d |ror...@E|XAMPLES=|
|00002780| 0a 0a 40 53 45 45 41 4c | 53 4f 3d 41 43 43 52 49 |..@SEEAL|SO=ACCRI|
|00002790| 4e 54 4d 00 40 46 55 4e | 43 54 49 4f 4e 3d 41 43 |NTM.@FUN|CTION=AC|
|000027a0| 43 52 49 4e 54 4d 0a 40 | 53 59 4e 54 41 58 3d 41 |CRINTM.@|SYNTAX=A|
|000027b0| 43 43 52 49 4e 54 4d 28 | 69 73 73 75 65 2c 6d 61 |CCRINTM(|issue,ma|
|000027c0| 74 75 72 69 74 79 2c 72 | 61 74 65 5b 2c 70 61 72 |turity,r|ate[,par|
|000027d0| 2c 62 61 73 69 73 5d 29 | 0a 40 44 45 53 43 52 49 |,basis])|.@DESCRI|
|000027e0| 50 54 49 4f 4e 3d 41 43 | 43 52 49 4e 54 4d 20 63 |PTION=AC|CRINTM c|
|000027f0| 61 6c 63 75 6c 61 74 65 | 73 20 61 6e 64 20 72 65 |alculate|s and re|
|00002800| 74 75 72 6e 73 20 74 68 | 65 20 61 63 63 72 75 65 |turns th|e accrue|
|00002810| 64 20 69 6e 74 65 72 65 | 73 74 20 66 6f 72 20 61 |d intere|st for a|
|00002820| 20 73 65 63 75 72 69 74 | 79 20 66 72 6f 6d 20 40 | securit|y from @|
|00002830| 69 73 73 75 65 20 74 6f | 20 40 6d 61 74 75 72 69 |issue to| @maturi|
|00002840| 74 79 20 64 61 74 65 2e | 0a 0a 40 69 73 73 75 65 |ty date.|..@issue|
|00002850| 20 69 73 20 74 68 65 20 | 69 73 73 75 65 20 64 61 | is the |issue da|
|00002860| 74 65 20 6f 66 20 74 68 | 65 20 73 65 63 75 72 69 |te of th|e securi|
|00002870| 74 79 2e 20 20 40 6d 61 | 74 75 72 69 74 79 20 69 |ty.  @ma|turity i|
|00002880| 73 20 74 68 65 20 6d 61 | 74 75 72 69 74 79 20 64 |s the ma|turity d|
|00002890| 61 74 65 20 6f 66 20 74 | 68 65 20 73 65 63 75 72 |ate of t|he secur|
|000028a0| 69 74 79 2e 20 20 40 72 | 61 74 65 20 69 73 20 74 |ity.  @r|ate is t|
|000028b0| 68 65 20 61 6e 6e 75 61 | 6c 20 72 61 74 65 20 6f |he annua|l rate o|
|000028c0| 66 20 74 68 65 20 73 65 | 63 75 72 69 74 79 20 61 |f the se|curity a|
|000028d0| 6e 64 20 40 70 61 72 20 | 69 73 20 74 68 65 20 70 |nd @par |is the p|
|000028e0| 61 72 20 76 61 6c 75 65 | 20 6f 66 20 74 68 65 20 |ar value| of the |
|000028f0| 73 65 63 75 72 69 74 79 | 2e 20 49 66 20 79 6f 75 |security|. If you|
|00002900| 20 6f 6d 69 74 20 40 70 | 61 72 2c 20 41 43 43 52 | omit @p|ar, ACCR|
|00002910| 49 4e 54 4d 20 61 70 70 | 6c 69 65 73 20 24 31 2c |INTM app|lies $1,|
|00002920| 30 30 30 20 69 6e 73 74 | 65 61 64 2e 20 20 40 62 |000 inst|ead.  @b|
|00002930| 61 73 69 73 20 69 73 20 | 74 68 65 20 74 79 70 65 |asis is |the type|
|00002940| 20 6f 66 20 64 61 79 20 | 63 6f 75 6e 74 69 6e 67 | of day |counting|
|00002950| 20 73 79 73 74 65 6d 20 | 79 6f 75 20 77 61 6e 74 | system |you want|
|00002960| 20 74 6f 20 75 73 65 3a | 0a 0a 20 20 30 20 20 55 | to use:|..  0  U|
|00002970| 53 20 33 30 2f 33 36 30 | 0a 20 20 31 20 20 61 63 |S 30/360|.  1  ac|
|00002980| 74 75 61 6c 20 64 61 79 | 73 2f 61 63 74 75 61 6c |tual day|s/actual|
|00002990| 20 64 61 79 73 0a 20 20 | 32 20 20 61 63 74 75 61 | days.  |2  actua|
|000029a0| 6c 20 64 61 79 73 2f 33 | 36 30 0a 20 20 33 20 20 |l days/3|60.  3  |
|000029b0| 61 63 74 75 61 6c 20 64 | 61 79 73 2f 33 36 35 0a |actual d|ays/365.|
|000029c0| 20 20 34 20 20 45 75 72 | 6f 70 65 61 6e 20 33 30 |  4  Eur|opean 30|
|000029d0| 2f 33 36 30 0a 0a 2a 20 | 49 66 20 40 69 73 73 75 |/360..* |If @issu|
|000029e0| 65 20 64 61 74 65 20 6f | 72 20 40 6d 61 74 75 72 |e date o|r @matur|
|000029f0| 69 74 79 20 64 61 74 65 | 20 69 73 20 6e 6f 74 20 |ity date| is not |
|00002a00| 76 61 6c 69 64 2c 20 41 | 43 43 52 49 4e 54 4d 20 |valid, A|CCRINTM |
|00002a10| 72 65 74 75 72 6e 73 20 | 23 4e 55 4d 21 20 65 72 |returns |#NUM! er|
|00002a20| 72 6f 72 2e 0a 2a 20 49 | 66 20 40 72 61 74 65 20 |ror..* I|f @rate |
|00002a30| 3c 3d 20 30 20 6f 72 20 | 40 70 61 72 20 3c 3d 20 |<= 0 or |@par <= |
|00002a40| 30 2c 20 41 43 43 52 49 | 4e 54 4d 20 72 65 74 75 |0, ACCRI|NTM retu|
|00002a50| 72 6e 73 20 23 4e 55 4d | 21 20 65 72 72 6f 72 2e |rns #NUM|! error.|
|00002a60| 0a 2a 20 49 66 20 40 62 | 61 73 69 73 20 69 73 20 |.* If @b|asis is |
|00002a70| 6f 6d 69 74 74 65 64 2c | 20 55 53 20 33 30 2f 33 |omitted,| US 30/3|
|00002a80| 36 30 20 69 73 20 61 70 | 70 6c 69 65 64 2e 0a 2a |60 is ap|plied..*|
|00002a90| 20 49 66 20 40 62 61 73 | 69 73 20 3c 20 30 20 6f | If @bas|is < 0 o|
|00002aa0| 72 20 40 62 61 73 69 73 | 20 3e 20 34 2c 20 41 43 |r @basis| > 4, AC|
|00002ab0| 43 52 49 4e 54 4d 20 72 | 65 74 75 72 6e 73 20 23 |CRINTM r|eturns #|
|00002ac0| 4e 55 4d 21 20 65 72 72 | 6f 72 2e 0a 2a 20 49 66 |NUM! err|or..* If|
|00002ad0| 20 40 69 73 73 75 65 20 | 64 61 74 65 20 69 73 20 | @issue |date is |
|00002ae0| 61 66 74 65 72 20 40 6d | 61 74 75 72 69 74 79 20 |after @m|aturity |
|00002af0| 64 61 74 65 20 6f 72 20 | 74 68 65 79 20 61 72 65 |date or |they are|
|00002b00| 20 74 68 65 20 73 61 6d | 65 2c 20 41 43 43 52 49 | the sam|e, ACCRI|
|00002b10| 4e 54 4d 20 72 65 74 75 | 72 6e 73 20 23 4e 55 4d |NTM retu|rns #NUM|
|00002b20| 21 20 65 72 72 6f 72 2e | 0a 0a 40 45 58 41 4d 50 |! error.|..@EXAMP|
|00002b30| 4c 45 53 3d 0a 0a 40 53 | 45 45 41 4c 53 4f 3d 41 |LES=..@S|EEALSO=A|
|00002b40| 43 43 52 49 4e 54 00 40 | 46 55 4e 43 54 49 4f 4e |CCRINT.@|FUNCTION|
|00002b50| 3d 41 43 4f 53 0a 40 53 | 59 4e 54 41 58 3d 41 43 |=ACOS.@S|YNTAX=AC|
|00002b60| 4f 53 28 78 29 0a 40 44 | 45 53 43 52 49 50 54 49 |OS(x).@D|ESCRIPTI|
|00002b70| 4f 4e 3d 41 43 4f 53 20 | 66 75 6e 63 74 69 6f 6e |ON=ACOS |function|
|00002b80| 20 63 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 | calcula|tes the |
|00002b90| 61 72 63 20 63 6f 73 69 | 6e 65 20 6f 66 20 40 78 |arc cosi|ne of @x|
|00002ba0| 3b 20 74 68 61 74 20 69 | 73 20 74 68 65 20 76 61 |; that i|s the va|
|00002bb0| 6c 75 65 20 77 68 6f 73 | 65 20 63 6f 73 69 6e 65 |lue whos|e cosine|
|00002bc0| 20 69 73 20 40 78 2e 0a | 0a 2a 20 54 68 65 20 76 | is @x..|.* The v|
|00002bd0| 61 6c 75 65 20 69 74 20 | 72 65 74 75 72 6e 73 20 |alue it |returns |
|00002be0| 69 73 20 69 6e 20 72 61 | 64 69 61 6e 73 2e 0a 2a |is in ra|dians..*|
|00002bf0| 20 49 66 20 40 78 20 66 | 61 6c 6c 73 20 6f 75 74 | If @x f|alls out|
|00002c00| 73 69 64 65 20 74 68 65 | 20 72 61 6e 67 65 20 2d |side the| range -|
|00002c10| 31 20 74 6f 20 31 2c 20 | 41 43 4f 53 20 72 65 74 |1 to 1, |ACOS ret|
|00002c20| 75 72 6e 73 20 74 68 65 | 20 23 4e 55 4d 21 20 65 |urns the| #NUM! e|
|00002c30| 72 72 6f 72 2e 0a 2a 20 | 54 68 69 73 20 66 75 6e |rror..* |This fun|
|00002c40| 63 74 69 6f 6e 20 69 73 | 20 45 78 63 65 6c 20 63 |ction is| Excel c|
|00002c50| 6f 6d 70 61 74 69 62 6c | 65 2e 0a 0a 40 45 58 41 |ompatibl|e...@EXA|
|00002c60| 4d 50 4c 45 53 3d 0a 41 | 43 4f 53 28 30 2e 31 29 |MPLES=.A|COS(0.1)|
|00002c70| 20 65 71 75 61 6c 73 20 | 31 2e 34 37 30 36 32 39 | equals |1.470629|
|00002c80| 2e 0a 41 43 4f 53 28 2d | 30 2e 31 29 20 65 71 75 |..ACOS(-|0.1) equ|
|00002c90| 61 6c 73 20 31 2e 36 37 | 30 39 36 34 2e 0a 0a 40 |als 1.67|0964...@|
|00002ca0| 53 45 45 41 4c 53 4f 3d | 43 4f 53 2c 20 53 49 4e |SEEALSO=|COS, SIN|
|00002cb0| 2c 20 44 45 47 52 45 45 | 53 2c 20 52 41 44 49 41 |, DEGREE|S, RADIA|
|00002cc0| 4e 53 00 40 46 55 4e 43 | 54 49 4f 4e 3d 41 43 4f |NS.@FUNC|TION=ACO|
|00002cd0| 53 48 0a 40 53 59 4e 54 | 41 58 3d 41 43 4f 53 48 |SH.@SYNT|AX=ACOSH|
|00002ce0| 28 78 29 0a 40 44 45 53 | 43 52 49 50 54 49 4f 4e |(x).@DES|CRIPTION|
|00002cf0| 3d 41 43 4f 53 48 20 20 | 66 75 6e 63 74 69 6f 6e |=ACOSH  |function|
|00002d00| 20 20 63 61 6c 63 75 6c | 61 74 65 73 20 20 74 68 |  calcul|ates  th|
|00002d10| 65 20 69 6e 76 65 72 73 | 65 20 68 79 70 65 72 62 |e invers|e hyperb|
|00002d20| 6f 6c 69 63 20 63 6f 73 | 69 6e 65 20 6f 66 20 40 |olic cos|ine of @|
|00002d30| 78 3b 20 74 68 61 74 20 | 69 73 20 74 68 65 20 76 |x; that |is the v|
|00002d40| 61 6c 75 65 20 77 68 6f | 73 65 20 68 79 70 65 72 |alue who|se hyper|
|00002d50| 62 6f 6c 69 63 20 63 6f | 73 69 6e 65 20 69 73 20 |bolic co|sine is |
|00002d60| 40 78 2e 0a 0a 2a 20 49 | 66 20 40 78 20 69 73 20 |@x...* I|f @x is |
|00002d70| 6c 65 73 73 20 74 68 61 | 6e 20 31 2e 30 2c 20 41 |less tha|n 1.0, A|
|00002d80| 43 4f 53 48 28 29 20 72 | 65 74 75 72 6e 73 20 74 |COSH() r|eturns t|
|00002d90| 68 65 20 23 4e 55 4d 21 | 20 65 72 72 6f 72 2e 0a |he #NUM!| error..|
|00002da0| 2a 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |* This f|unction |
|00002db0| 69 73 20 45 78 63 65 6c | 20 63 6f 6d 70 61 74 69 |is Excel| compati|
|00002dc0| 62 6c 65 2e 0a 20 0a 40 | 45 58 41 4d 50 4c 45 53 |ble.. .@|EXAMPLES|
|00002dd0| 3d 0a 41 43 4f 53 48 28 | 32 29 20 65 71 75 61 6c |=.ACOSH(|2) equal|
|00002de0| 73 20 31 2e 33 31 36 39 | 36 2e 0a 41 43 4f 53 48 |s 1.3169|6..ACOSH|
|00002df0| 28 35 2e 33 29 20 65 71 | 75 61 6c 73 20 32 2e 33 |(5.3) eq|uals 2.3|
|00002e00| 35 31 38 33 2e 0a 0a 40 | 53 45 45 41 4c 53 4f 3d |5183...@|SEEALSO=|
|00002e10| 41 43 4f 53 2c 20 41 53 | 49 4e 48 2c 20 44 45 47 |ACOS, AS|INH, DEG|
|00002e20| 52 45 45 53 2c 20 52 41 | 44 49 41 4e 53 20 00 40 |REES, RA|DIANS .@|
|00002e30| 46 55 4e 43 54 49 4f 4e | 3d 41 44 44 52 45 53 53 |FUNCTION|=ADDRESS|
|00002e40| 0a 40 53 59 4e 54 41 58 | 3d 41 44 44 52 45 53 53 |.@SYNTAX|=ADDRESS|
|00002e50| 28 72 6f 77 5f 6e 75 6d | 2c 63 6f 6c 5f 6e 75 6d |(row_num|,col_num|
|00002e60| 5b 2c 61 62 73 5f 6e 75 | 6d 2c 61 31 2c 74 65 78 |[,abs_nu|m,a1,tex|
|00002e70| 74 5d 29 0a 40 44 45 53 | 43 52 49 50 54 49 4f 4e |t]).@DES|CRIPTION|
|00002e80| 3d 41 44 44 52 45 53 53 | 20 72 65 74 75 72 6e 73 |=ADDRESS| returns|
|00002e90| 20 61 20 63 65 6c 6c 20 | 61 64 64 72 65 73 73 20 | a cell |address |
|00002ea0| 61 73 20 74 65 78 74 20 | 66 6f 72 20 73 70 65 63 |as text |for spec|
|00002eb0| 69 66 69 65 64 20 72 6f | 77 20 61 6e 64 20 63 6f |ified ro|w and co|
|00002ec0| 6c 75 6d 6e 20 6e 75 6d | 62 65 72 73 2e 0a 0a 40 |lumn num|bers...@|
|00002ed0| 61 31 20 69 73 20 61 20 | 6c 6f 67 69 63 61 6c 20 |a1 is a |logical |
|00002ee0| 76 61 6c 75 65 20 74 68 | 61 74 20 73 70 65 63 69 |value th|at speci|
|00002ef0| 66 69 65 73 20 74 68 65 | 20 72 65 66 65 72 65 6e |fies the| referen|
|00002f00| 63 65 20 73 74 79 6c 65 | 2e 20 20 49 66 20 40 61 |ce style|.  If @a|
|00002f10| 31 20 69 73 20 54 52 55 | 45 20 6f 72 20 6f 6d 69 |1 is TRU|E or omi|
|00002f20| 74 74 65 64 2c 20 41 44 | 44 52 45 53 53 20 72 65 |tted, AD|DRESS re|
|00002f30| 74 75 72 6e 73 20 61 6e | 20 41 31 2d 73 74 79 6c |turns an| A1-styl|
|00002f40| 65 20 72 65 66 65 72 65 | 6e 63 65 2c 20 69 2e 65 |e refere|nce, i.e|
|00002f50| 2e 20 24 44 24 34 2e 20 | 20 4f 74 68 65 72 77 69 |. $D$4. | Otherwi|
|00002f60| 73 65 20 41 44 44 52 45 | 53 53 20 72 65 74 75 72 |se ADDRE|SS retur|
|00002f70| 6e 73 20 61 6e 20 52 31 | 43 31 2d 73 74 79 6c 65 |ns an R1|C1-style|
|00002f80| 20 72 65 66 65 72 65 6e | 63 65 2c 20 69 2e 65 2e | referen|ce, i.e.|
|00002f90| 20 52 34 43 34 2e 0a 0a | 40 74 65 78 74 20 73 70 | R4C4...|@text sp|
|00002fa0| 65 63 69 66 69 65 73 20 | 74 68 65 20 6e 61 6d 65 |ecifies |the name|
|00002fb0| 20 6f 66 20 74 68 65 20 | 77 6f 72 6b 73 68 65 65 | of the |workshee|
|00002fc0| 74 20 74 6f 20 62 65 20 | 75 73 65 64 20 61 73 20 |t to be |used as |
|00002fd0| 74 68 65 20 65 78 74 65 | 72 6e 61 6c 20 72 65 66 |the exte|rnal ref|
|00002fe0| 65 72 65 6e 63 65 2e 0a | 0a 2a 20 49 66 20 40 61 |erence..|.* If @a|
|00002ff0| 62 73 5f 6e 75 6d 20 69 | 73 20 31 20 6f 72 20 6f |bs_num i|s 1 or o|
|00003000| 6d 69 74 74 65 64 2c 20 | 41 44 44 52 45 53 53 20 |mitted, |ADDRESS |
|00003010| 72 65 74 75 72 6e 73 20 | 61 62 73 6f 6c 75 74 65 |returns |absolute|
|00003020| 20 72 65 66 65 72 65 6e | 63 65 2e 0a 2a 20 49 66 | referen|ce..* If|
|00003030| 20 40 61 62 73 5f 6e 75 | 6d 20 69 73 20 32 20 41 | @abs_nu|m is 2 A|
|00003040| 44 44 52 45 53 53 20 72 | 65 74 75 72 6e 73 20 61 |DDRESS r|eturns a|
|00003050| 62 73 6f 6c 75 74 65 20 | 72 6f 77 20 61 6e 64 20 |bsolute |row and |
|00003060| 72 65 6c 61 74 69 76 65 | 20 63 6f 6c 75 6d 6e 2e |relative| column.|
|00003070| 0a 2a 20 49 66 20 40 61 | 62 73 5f 6e 75 6d 20 69 |.* If @a|bs_num i|
|00003080| 73 20 33 20 41 44 44 52 | 45 53 53 20 72 65 74 75 |s 3 ADDR|ESS retu|
|00003090| 72 6e 73 20 72 65 6c 61 | 74 69 76 65 20 72 6f 77 |rns rela|tive row|
|000030a0| 20 61 6e 64 20 61 62 73 | 6f 6c 75 74 65 20 63 6f | and abs|olute co|
|000030b0| 6c 75 6d 6e 2e 0a 2a 20 | 49 66 20 40 61 62 73 5f |lumn..* |If @abs_|
|000030c0| 6e 75 6d 20 69 73 20 34 | 20 41 44 44 52 45 53 53 |num is 4| ADDRESS|
|000030d0| 20 72 65 74 75 72 6e 73 | 20 72 65 6c 61 74 69 76 | returns| relativ|
|000030e0| 65 20 72 65 66 65 72 65 | 6e 63 65 2e 0a 2a 20 49 |e refere|nce..* I|
|000030f0| 66 20 40 61 62 73 5f 6e | 75 6d 20 69 73 20 67 72 |f @abs_n|um is gr|
|00003100| 65 61 74 65 72 20 74 68 | 61 6e 20 34 20 41 44 44 |eater th|an 4 ADD|
|00003110| 52 45 53 53 20 72 65 74 | 75 72 6e 73 20 23 56 41 |RESS ret|urns #VA|
|00003120| 4c 55 45 21 20 65 72 72 | 6f 72 2e 0a 2a 20 49 66 |LUE! err|or..* If|
|00003130| 20 40 72 6f 77 5f 6e 75 | 6d 20 6f 72 20 40 63 6f | @row_nu|m or @co|
|00003140| 6c 5f 6e 75 6d 20 69 73 | 20 6c 65 73 73 20 74 68 |l_num is| less th|
|00003150| 61 6e 20 6f 6e 65 2c 20 | 41 44 44 52 45 53 53 20 |an one, |ADDRESS |
|00003160| 72 65 74 75 72 6e 73 20 | 23 56 41 4c 55 45 21 20 |returns |#VALUE! |
|00003170| 65 72 72 6f 72 2e 0a 0a | 40 45 58 41 4d 50 4c 45 |error...|@EXAMPLE|
|00003180| 53 3d 0a 41 44 44 52 45 | 53 53 28 35 2c 34 29 20 |S=.ADDRE|SS(5,4) |
|00003190| 65 71 75 61 6c 73 20 22 | 24 44 24 35 22 2e 0a 41 |equals "|$D$5"..A|
|000031a0| 44 44 52 45 53 53 28 35 | 2c 34 2c 34 29 20 65 71 |DDRESS(5|,4,4) eq|
|000031b0| 75 61 6c 73 20 22 44 35 | 22 2e 0a 41 44 44 52 45 |uals "D5|"..ADDRE|
|000031c0| 53 53 28 35 2c 34 2c 33 | 2c 46 41 4c 53 45 29 20 |SS(5,4,3|,FALSE) |
|000031d0| 65 71 75 61 6c 73 20 22 | 52 5b 35 5d 43 34 22 2e |equals "|R[5]C4".|
|000031e0| 0a 0a 40 53 45 45 41 4c | 53 4f 3d 43 4f 4c 55 4d |..@SEEAL|SO=COLUM|
|000031f0| 4e 4e 55 4d 42 45 52 00 | 40 46 55 4e 43 54 49 4f |NNUMBER.|@FUNCTIO|
|00003200| 4e 3d 41 4d 4f 52 44 45 | 47 52 43 0a 40 53 59 4e |N=AMORDE|GRC.@SYN|
|00003210| 54 41 58 3d 41 4d 4f 52 | 44 45 47 52 43 28 63 6f |TAX=AMOR|DEGRC(co|
|00003220| 73 74 2c 70 75 72 63 68 | 61 73 65 5f 64 61 74 65 |st,purch|ase_date|
|00003230| 2c 66 69 72 73 74 5f 70 | 65 72 69 6f 64 2c 73 61 |,first_p|eriod,sa|
|00003240| 6c 76 61 67 65 2c 70 65 | 72 69 6f 64 2c 72 61 74 |lvage,pe|riod,rat|
|00003250| 65 5b 2c 62 61 73 69 73 | 5d 29 0a 40 44 45 53 43 |e[,basis|]).@DESC|
|00003260| 52 49 50 54 49 4f 4e 3d | 41 4d 4f 52 44 45 47 52 |RIPTION=|AMORDEGR|
|00003270| 43 3a 20 43 61 6c 63 75 | 6c 61 74 65 73 20 64 65 |C: Calcu|lates de|
|00003280| 70 72 65 63 69 61 74 69 | 6f 6e 20 66 6f 72 20 65 |preciati|on for e|
|00003290| 61 63 68 20 61 63 63 6f | 75 6e 74 69 6e 67 20 70 |ach acco|unting p|
|000032a0| 65 72 69 6f 64 20 75 73 | 69 6e 67 20 46 72 65 6e |eriod us|ing Fren|
|000032b0| 63 68 20 61 63 63 6f 75 | 6e 74 69 6e 67 20 63 6f |ch accou|nting co|
|000032c0| 6e 76 65 6e 74 69 6f 6e | 73 2e 20 20 20 41 73 73 |nvention|s.   Ass|
|000032d0| 65 74 73 20 70 75 72 63 | 68 61 73 65 64 20 69 6e |ets purc|hased in|
|000032e0| 20 74 68 65 20 6d 69 64 | 64 6c 65 20 6f 66 20 61 | the mid|dle of a|
|000032f0| 20 70 65 72 69 6f 64 20 | 74 61 6b 65 20 70 72 6f | period |take pro|
|00003300| 72 61 74 65 64 20 64 65 | 70 72 65 63 69 61 74 69 |rated de|preciati|
|00003310| 6f 6e 20 69 6e 74 6f 20 | 61 63 63 6f 75 6e 74 2e |on into |account.|
|00003320| 20 20 54 68 69 73 20 69 | 73 20 73 69 6d 69 6c 61 |  This i|s simila|
|00003330| 72 20 74 6f 20 41 4d 4f | 52 4c 49 4e 43 2c 20 65 |r to AMO|RLINC, e|
|00003340| 78 63 65 70 74 20 74 68 | 61 74 20 61 20 64 65 70 |xcept th|at a dep|
|00003350| 72 65 63 69 61 74 69 6f | 6e 20 63 6f 65 66 66 69 |reciatio|n coeffi|
|00003360| 63 69 65 6e 74 20 69 73 | 20 61 70 70 6c 69 65 64 |cient is| applied|
|00003370| 20 69 6e 20 74 68 65 20 | 63 61 6c 63 75 6c 61 74 | in the |calculat|
|00003380| 69 6f 6e 20 64 65 70 65 | 6e 64 69 6e 67 20 6f 6e |ion depe|nding on|
|00003390| 20 74 68 65 20 6c 69 66 | 65 20 6f 66 20 74 68 65 | the lif|e of the|
|000033a0| 20 61 73 73 65 74 73 2e | 0a 4e 61 6d 65 64 20 66 | assets.|.Named f|
|000033b0| 6f 72 20 41 4d 4f 52 74 | 69 73 73 65 6d 65 6e 74 |or AMORt|issement|
|000033c0| 20 44 45 47 52 65 73 73 | 69 66 20 43 6f 6d 70 74 | DEGRess|if Compt|
|000033d0| 61 62 69 6c 69 74 65 0a | 0a 40 63 6f 73 74 20 54 |abilite.|.@cost T|
|000033e0| 68 65 20 76 61 6c 75 65 | 20 6f 66 20 74 68 65 20 |he value| of the |
|000033f0| 61 73 73 65 74 2e 0a 40 | 70 75 72 63 68 61 73 65 |asset..@|purchase|
|00003400| 5f 64 61 74 65 20 54 68 | 65 20 64 61 74 65 20 74 |_date Th|e date t|
|00003410| 68 65 20 61 73 73 65 74 | 20 77 61 73 20 70 75 72 |he asset| was pur|
|00003420| 63 68 61 73 65 64 2e 0a | 40 66 69 72 73 74 5f 70 |chased..|@first_p|
|00003430| 65 72 69 6f 64 20 54 68 | 65 20 65 6e 64 20 6f 66 |eriod Th|e end of|
|00003440| 20 74 68 65 20 66 69 72 | 73 74 20 70 65 72 69 6f | the fir|st perio|
|00003450| 64 2e 0a 40 73 61 6c 76 | 61 67 65 20 41 73 73 65 |d..@salv|age Asse|
|00003460| 74 20 76 61 6c 75 65 20 | 61 74 20 6d 61 74 75 72 |t value |at matur|
|00003470| 69 74 79 2e 0a 40 70 65 | 72 69 6f 64 20 54 68 65 |ity..@pe|riod The|
|00003480| 20 6c 65 6e 67 74 68 20 | 6f 66 20 61 63 63 6f 75 | length |of accou|
|00003490| 6e 74 69 6e 67 20 70 65 | 72 69 6f 64 73 2e 0a 40 |nting pe|riods..@|
|000034a0| 72 61 74 65 20 72 61 74 | 65 20 6f 66 20 64 65 70 |rate rat|e of dep|
|000034b0| 72 65 63 69 61 74 69 6f | 6e 20 61 73 20 61 20 70 |reciatio|n as a p|
|000034c0| 65 72 63 65 6e 74 61 67 | 65 2e 0a 40 62 61 73 69 |ercentag|e..@basi|
|000034d0| 73 20 69 73 20 74 68 65 | 20 74 79 70 65 20 6f 66 |s is the| type of|
|000034e0| 20 64 61 79 20 63 6f 75 | 6e 74 69 6e 67 20 73 79 | day cou|nting sy|
|000034f0| 73 74 65 6d 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |stem you| want to|
|00003500| 20 75 73 65 3a 0a 0a 20 | 20 30 20 20 55 53 20 33 | use:.. | 0  US 3|
|00003510| 30 2f 33 36 30 0a 20 20 | 31 20 20 61 63 74 75 61 |0/360.  |1  actua|
|00003520| 6c 20 64 61 79 73 2f 61 | 63 74 75 61 6c 20 64 61 |l days/a|ctual da|
|00003530| 79 73 0a 20 20 32 20 20 | 61 63 74 75 61 6c 20 64 |ys.  2  |actual d|
|00003540| 61 79 73 2f 33 36 30 0a | 20 20 33 20 20 61 63 74 |ays/360.|  3  act|
|00003550| 75 61 6c 20 64 61 79 73 | 2f 33 36 35 0a 20 20 34 |ual days|/365.  4|
|00003560| 20 20 45 75 72 6f 70 65 | 61 6e 20 33 30 2f 33 36 |  Europe|an 30/36|
|00003570| 30 0a 0a 2a 20 49 66 20 | 40 62 61 73 69 73 20 69 |0..* If |@basis i|
|00003580| 73 20 6f 6d 69 74 74 65 | 64 2c 20 55 53 20 33 30 |s omitte|d, US 30|
|00003590| 2f 33 36 30 20 69 73 20 | 61 70 70 6c 69 65 64 2e |/360 is |applied.|
|000035a0| 0a 2a 20 49 66 20 40 62 | 61 73 69 73 20 69 73 20 |.* If @b|asis is |
|000035b0| 6e 6f 74 20 69 6e 20 62 | 65 74 77 65 65 6e 20 30 |not in b|etween 0|
|000035c0| 20 61 6e 64 20 34 2c 20 | 23 4e 55 4d 21 20 65 72 | and 4, |#NUM! er|
|000035d0| 72 6f 72 20 69 73 20 72 | 65 74 75 72 6e 65 64 2e |ror is r|eturned.|
|000035e0| 0a 0a 40 45 58 41 4d 50 | 4c 45 53 3d 0a 41 4d 4f |..@EXAMP|LES=.AMO|
|000035f0| 52 44 45 47 52 43 28 32 | 34 30 30 2c 44 41 54 45 |RDEGRC(2|400,DATE|
|00003600| 28 31 39 39 38 2c 38 2c | 31 39 29 2c 44 41 54 45 |(1998,8,|19),DATE|
|00003610| 28 31 39 39 38 2c 31 32 | 2c 33 30 29 2c 33 30 30 |(1998,12|,30),300|
|00003620| 2c 31 2c 30 2e 31 34 2c | 31 29 20 3d 20 37 33 33 |,1,0.14,|1) = 733|
|00003630| 0a 0a 40 53 45 45 41 4c | 53 4f 3d 41 4d 4f 52 4c |..@SEEAL|SO=AMORL|
|00003640| 49 4e 43 00 40 46 55 4e | 43 54 49 4f 4e 3d 41 4d |INC.@FUN|CTION=AM|
|00003650| 4f 52 4c 49 4e 43 0a 40 | 53 59 4e 54 41 58 3d 41 |ORLINC.@|SYNTAX=A|
|00003660| 4d 4f 52 4c 49 4e 43 28 | 63 6f 73 74 2c 70 75 72 |MORLINC(|cost,pur|
|00003670| 63 68 61 73 65 5f 64 61 | 74 65 2c 66 69 72 73 74 |chase_da|te,first|
|00003680| 5f 70 65 72 69 6f 64 2c | 73 61 6c 76 61 67 65 2c |_period,|salvage,|
|00003690| 70 65 72 69 6f 64 2c 72 | 61 74 65 5b 2c 62 61 73 |period,r|ate[,bas|
|000036a0| 69 73 5d 29 0a 40 44 45 | 53 43 52 49 50 54 49 4f |is]).@DE|SCRIPTIO|
|000036b0| 4e 3d 41 4d 4f 52 4c 49 | 4e 43 3a 20 43 61 6c 63 |N=AMORLI|NC: Calc|
|000036c0| 75 6c 61 74 65 73 20 64 | 65 70 72 65 63 69 61 74 |ulates d|epreciat|
|000036d0| 69 6f 6e 20 66 6f 72 20 | 65 61 63 68 20 61 63 63 |ion for |each acc|
|000036e0| 6f 75 6e 74 69 6e 67 20 | 70 65 72 69 6f 64 20 75 |ounting |period u|
|000036f0| 73 69 6e 67 20 46 72 65 | 6e 63 68 20 61 63 63 6f |sing Fre|nch acco|
|00003700| 75 6e 74 69 6e 67 20 63 | 6f 6e 76 65 6e 74 69 6f |unting c|onventio|
|00003710| 6e 73 2e 20 20 20 41 73 | 73 65 74 73 20 70 75 72 |ns.   As|sets pur|
|00003720| 63 68 61 73 65 64 20 69 | 6e 20 74 68 65 20 6d 69 |chased i|n the mi|
|00003730| 64 64 6c 65 20 6f 66 20 | 61 20 70 65 72 69 6f 64 |ddle of |a period|
|00003740| 20 74 61 6b 65 20 70 72 | 6f 72 61 74 65 64 20 64 | take pr|orated d|
|00003750| 65 70 72 65 63 69 61 74 | 69 6f 6e 20 69 6e 74 6f |epreciat|ion into|
|00003760| 20 61 63 63 6f 75 6e 74 | 2e 0a 4e 61 6d 65 64 20 | account|..Named |
|00003770| 66 6f 72 20 41 4d 4f 52 | 74 69 73 73 65 6d 65 6e |for AMOR|tissemen|
|00003780| 74 20 4c 49 4e 65 61 69 | 72 65 20 43 6f 6d 70 74 |t LINeai|re Compt|
|00003790| 61 62 69 6c 69 74 65 2e | 0a 0a 40 63 6f 73 74 20 |abilite.|..@cost |
|000037a0| 54 68 65 20 76 61 6c 75 | 65 20 6f 66 20 74 68 65 |The valu|e of the|
|000037b0| 20 61 73 73 65 74 2e 0a | 40 70 75 72 63 68 61 73 | asset..|@purchas|
|000037c0| 65 5f 64 61 74 65 20 54 | 68 65 20 64 61 74 65 20 |e_date T|he date |
|000037d0| 74 68 65 20 61 73 73 65 | 74 20 77 61 73 20 70 75 |the asse|t was pu|
|000037e0| 72 63 68 61 73 65 64 2e | 0a 40 66 69 72 73 74 5f |rchased.|.@first_|
|000037f0| 70 65 72 69 6f 64 20 54 | 68 65 20 65 6e 64 20 6f |period T|he end o|
|00003800| 66 20 74 68 65 20 66 69 | 72 73 74 20 70 65 72 69 |f the fi|rst peri|
|00003810| 6f 64 2e 0a 40 73 61 6c | 76 61 67 65 20 41 73 73 |od..@sal|vage Ass|
|00003820| 65 74 20 76 61 6c 75 65 | 20 61 74 20 6d 61 74 75 |et value| at matu|
|00003830| 72 69 74 79 2e 0a 40 70 | 65 72 69 6f 64 20 54 68 |rity..@p|eriod Th|
|00003840| 65 20 6c 65 6e 67 74 68 | 20 6f 66 20 61 63 63 6f |e length| of acco|
|00003850| 75 6e 74 69 6e 67 20 70 | 65 72 69 6f 64 73 2e 0a |unting p|eriods..|
|00003860| 40 72 61 74 65 20 72 61 | 74 65 20 6f 66 20 64 65 |@rate ra|te of de|
|00003870| 70 72 65 63 69 61 74 69 | 6f 6e 20 61 73 20 61 20 |preciati|on as a |
|00003880| 70 65 72 63 65 6e 74 61 | 67 65 2e 0a 40 62 61 73 |percenta|ge..@bas|
|00003890| 69 73 20 69 73 20 74 68 | 65 20 74 79 70 65 20 6f |is is th|e type o|
|000038a0| 66 20 64 61 79 20 63 6f | 75 6e 74 69 6e 67 20 73 |f day co|unting s|
|000038b0| 79 73 74 65 6d 20 79 6f | 75 20 77 61 6e 74 20 74 |ystem yo|u want t|
|000038c0| 6f 20 75 73 65 3a 0a 0a | 20 20 30 20 20 55 53 20 |o use:..|  0  US |
|000038d0| 33 30 2f 33 36 30 0a 20 | 20 31 20 20 61 63 74 75 |30/360. | 1  actu|
|000038e0| 61 6c 20 64 61 79 73 2f | 61 63 74 75 61 6c 20 64 |al days/|actual d|
|000038f0| 61 79 73 0a 20 20 32 20 | 20 61 63 74 75 61 6c 20 |ays.  2 | actual |
|00003900| 64 61 79 73 2f 33 36 30 | 0a 20 20 33 20 20 61 63 |days/360|.  3  ac|
|00003910| 74 75 61 6c 20 64 61 79 | 73 2f 33 36 35 0a 20 20 |tual day|s/365.  |
|00003920| 34 20 20 45 75 72 6f 70 | 65 61 6e 20 33 30 2f 33 |4  Europ|ean 30/3|
|00003930| 36 30 0a 0a 2a 20 49 66 | 20 40 62 61 73 69 73 20 |60..* If| @basis |
|00003940| 69 73 20 6f 6d 69 74 74 | 65 64 2c 20 55 53 20 33 |is omitt|ed, US 3|
|00003950| 30 2f 33 36 30 20 69 73 | 20 61 70 70 6c 69 65 64 |0/360 is| applied|
|00003960| 2e 0a 2a 20 49 66 20 40 | 62 61 73 69 73 20 69 73 |..* If @|basis is|
|00003970| 20 6e 6f 74 20 69 6e 20 | 62 65 74 77 65 65 6e 20 | not in |between |
|00003980| 30 20 61 6e 64 20 34 2c | 20 23 4e 55 4d 21 20 65 |0 and 4,| #NUM! e|
|00003990| 72 72 6f 72 20 69 73 20 | 72 65 74 75 72 6e 65 64 |rror is |returned|
|000039a0| 2e 0a 0a 40 45 58 41 4d | 50 4c 45 53 3d 0a 41 4d |...@EXAM|PLES=.AM|
|000039b0| 4f 52 4c 49 4e 43 28 32 | 34 30 30 2c 44 41 54 45 |ORLINC(2|400,DATE|
|000039c0| 28 31 39 39 38 2c 38 2c | 31 39 29 2c 44 41 54 45 |(1998,8,|19),DATE|
|000039d0| 28 31 39 39 38 2c 31 32 | 2c 33 31 29 2c 33 30 30 |(1998,12|,31),300|
|000039e0| 2c 31 2c 30 2e 31 35 2c | 31 29 20 3d 20 33 36 30 |,1,0.15,|1) = 360|
|000039f0| 0a 0a 40 53 45 45 41 4c | 53 4f 3d 41 4d 4f 52 44 |..@SEEAL|SO=AMORD|
|00003a00| 45 47 52 43 00 40 46 55 | 4e 43 54 49 4f 4e 3d 41 |EGRC.@FU|NCTION=A|
|00003a10| 52 45 41 53 0a 40 53 59 | 4e 54 41 58 3d 41 52 45 |REAS.@SY|NTAX=ARE|
|00003a20| 41 53 28 72 65 66 65 72 | 65 6e 63 65 29 0a 40 44 |AS(refer|ence).@D|
|00003a30| 45 53 43 52 49 50 54 49 | 4f 4e 3d 41 52 45 41 53 |ESCRIPTI|ON=AREAS|
|00003a40| 20 72 65 74 75 72 6e 73 | 20 74 68 65 20 6e 75 6d | returns| the num|
|00003a50| 62 65 72 20 6f 66 20 61 | 72 65 61 73 20 69 6e 20 |ber of a|reas in |
|00003a60| 40 72 65 66 65 72 65 6e | 63 65 2e 20 0a 0a 40 45 |@referen|ce. ..@E|
|00003a70| 58 41 4d 50 4c 45 53 3d | 0a 41 52 45 41 53 28 28 |XAMPLES=|.AREAS((|
|00003a80| 41 31 2c 42 32 2c 43 33 | 29 29 20 65 71 75 61 6c |A1,B2,C3|)) equal|
|00003a90| 73 20 33 2e 0a 0a 40 53 | 45 45 41 4c 53 4f 3d 41 |s 3...@S|EEALSO=A|
|00003aa0| 44 44 52 45 53 53 2c 49 | 4e 44 45 58 2c 49 4e 44 |DDRESS,I|NDEX,IND|
|00003ab0| 49 52 45 43 54 2c 4f 46 | 46 53 45 54 00 40 46 55 |IRECT,OF|FSET.@FU|
|00003ac0| 4e 43 54 49 4f 4e 3d 41 | 53 49 4e 0a 40 53 59 4e |NCTION=A|SIN.@SYN|
|00003ad0| 54 41 58 3d 41 53 49 4e | 28 78 29 0a 40 44 45 53 |TAX=ASIN|(x).@DES|
|00003ae0| 43 52 49 50 54 49 4f 4e | 3d 41 53 49 4e 20 66 75 |CRIPTION|=ASIN fu|
|00003af0| 6e 63 74 69 6f 6e 20 63 | 61 6c 63 75 6c 61 74 65 |nction c|alculate|
|00003b00| 73 20 74 68 65 20 61 72 | 63 20 73 69 6e 65 20 6f |s the ar|c sine o|
|00003b10| 66 20 40 78 3b 20 74 68 | 61 74 20 69 73 20 74 68 |f @x; th|at is th|
|00003b20| 65 20 76 61 6c 75 65 20 | 77 68 6f 73 65 20 73 69 |e value |whose si|
|00003b30| 6e 65 20 69 73 20 40 78 | 2e 0a 0a 2a 20 49 66 20 |ne is @x|...* If |
|00003b40| 40 78 20 66 61 6c 6c 73 | 20 6f 75 74 73 69 64 65 |@x falls| outside|
|00003b50| 20 74 68 65 20 72 61 6e | 67 65 20 2d 31 20 74 6f | the ran|ge -1 to|
|00003b60| 20 31 2c 20 41 53 49 4e | 20 72 65 74 75 72 6e 73 | 1, ASIN| returns|
|00003b70| 20 74 68 65 20 23 4e 55 | 4d 21 20 65 72 72 6f 72 | the #NU|M! error|
|00003b80| 2e 0a 2a 20 54 68 69 73 | 20 66 75 6e 63 74 69 6f |..* This| functio|
|00003b90| 6e 20 69 73 20 45 78 63 | 65 6c 20 63 6f 6d 70 61 |n is Exc|el compa|
|00003ba0| 74 69 62 6c 65 2e 0a 0a | 40 45 58 41 4d 50 4c 45 |tible...|@EXAMPLE|
|00003bb0| 53 3d 0a 41 53 49 4e 28 | 30 2e 35 29 20 65 71 75 |S=.ASIN(|0.5) equ|
|00003bc0| 61 6c 73 20 30 2e 35 32 | 33 35 39 39 2e 0a 41 53 |als 0.52|3599..AS|
|00003bd0| 49 4e 28 31 29 20 65 71 | 75 61 6c 73 20 31 2e 35 |IN(1) eq|uals 1.5|
|00003be0| 37 30 37 39 37 2e 0a 0a | 40 53 45 45 41 4c 53 4f |70797...|@SEEALSO|
|00003bf0| 3d 53 49 4e 2c 20 43 4f | 53 2c 20 41 53 49 4e 48 |=SIN, CO|S, ASINH|
|00003c00| 2c 20 44 45 47 52 45 45 | 53 2c 20 52 41 44 49 41 |, DEGREE|S, RADIA|
|00003c10| 4e 53 00 40 46 55 4e 43 | 54 49 4f 4e 3d 41 53 49 |NS.@FUNC|TION=ASI|
|00003c20| 4e 48 0a 40 53 59 4e 54 | 41 58 3d 41 53 49 4e 48 |NH.@SYNT|AX=ASINH|
|00003c30| 28 78 29 0a 40 44 45 53 | 43 52 49 50 54 49 4f 4e |(x).@DES|CRIPTION|
|00003c40| 3d 41 53 49 4e 48 20 66 | 75 6e 63 74 69 6f 6e 20 |=ASINH f|unction |
|00003c50| 63 61 6c 63 75 6c 61 74 | 65 73 20 74 68 65 20 69 |calculat|es the i|
|00003c60| 6e 76 65 72 73 65 20 68 | 79 70 65 72 62 6f 6c 69 |nverse h|yperboli|
|00003c70| 63 20 73 69 6e 65 20 6f | 66 20 40 78 3b 20 74 68 |c sine o|f @x; th|
|00003c80| 61 74 20 69 73 20 74 68 | 65 20 76 61 6c 75 65 20 |at is th|e value |
|00003c90| 77 68 6f 73 65 20 68 79 | 70 65 72 62 6f 6c 69 63 |whose hy|perbolic|
|00003ca0| 20 73 69 6e 65 20 69 73 | 20 40 78 2e 0a 0a 2a 20 | sine is| @x...* |
|00003cb0| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 69 73 |This fun|ction is|
|00003cc0| 20 45 78 63 65 6c 20 63 | 6f 6d 70 61 74 69 62 6c | Excel c|ompatibl|
|00003cd0| 65 2e 0a 0a 40 45 58 41 | 4d 50 4c 45 53 3d 0a 41 |e...@EXA|MPLES=.A|
|00003ce0| 53 49 4e 48 28 30 2e 35 | 29 20 65 71 75 61 6c 73 |SINH(0.5|) equals|
|00003cf0| 20 30 2e 34 38 31 32 31 | 32 2e 0a 41 53 49 4e 48 | 0.48121|2..ASINH|
|00003d00| 28 31 2e 30 29 20 65 71 | 75 61 6c 73 20 30 2e 38 |(1.0) eq|uals 0.8|
|00003d10| 38 31 33 37 34 2e 0a 0a | 40 53 45 45 41 4c 53 4f |81374...|@SEEALSO|
|00003d20| 3d 41 53 49 4e 2c 20 41 | 43 4f 53 48 2c 20 53 49 |=ASIN, A|COSH, SI|
|00003d30| 4e 2c 20 43 4f 53 2c 20 | 44 45 47 52 45 45 53 2c |N, COS, |DEGREES,|
|00003d40| 20 52 41 44 49 41 4e 53 | 00 40 46 55 4e 43 54 49 | RADIANS|.@FUNCTI|
|00003d50| 4f 4e 3d 41 54 41 4e 0a | 40 53 59 4e 54 41 58 3d |ON=ATAN.|@SYNTAX=|
|00003d60| 41 54 41 4e 28 78 29 0a | 40 44 45 53 43 52 49 50 |ATAN(x).|@DESCRIP|
|00003d70| 54 49 4f 4e 3d 41 54 41 | 4e 20 66 75 6e 63 74 69 |TION=ATA|N functi|
|00003d80| 6f 6e 20 63 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |on calcu|lates th|
|00003d90| 65 20 61 72 63 20 74 61 | 6e 67 65 6e 74 20 6f 66 |e arc ta|ngent of|
|00003da0| 20 40 78 3b 20 74 68 61 | 74 20 69 73 20 74 68 65 | @x; tha|t is the|
|00003db0| 20 76 61 6c 75 65 20 77 | 68 6f 73 65 20 74 61 6e | value w|hose tan|
|00003dc0| 67 65 6e 74 20 69 73 20 | 40 78 2e 0a 0a 2a 20 52 |gent is |@x...* R|
|00003dd0| 65 74 75 72 6e 20 76 61 | 6c 75 65 20 69 73 20 69 |eturn va|lue is i|
|00003de0| 6e 20 72 61 64 69 61 6e | 73 2e 0a 2a 20 54 68 69 |n radian|s..* Thi|
|00003df0| 73 20 66 75 6e 63 74 69 | 6f 6e 20 69 73 20 45 78 |s functi|on is Ex|
|00003e00| 63 65 6c 20 63 6f 6d 70 | 61 74 69 62 6c 65 2e 0a |cel comp|atible..|
|00003e10| 0a 40 45 58 41 4d 50 4c | 45 53 3d 0a 41 54 41 4e |.@EXAMPL|ES=.ATAN|
|00003e20| 28 30 2e 35 29 20 65 71 | 75 61 6c 73 20 30 2c 34 |(0.5) eq|uals 0,4|
|00003e30| 36 33 36 34 38 2e 0a 41 | 54 41 4e 28 31 29 20 65 |63648..A|TAN(1) e|
|00003e40| 71 75 61 6c 73 20 30 2c | 37 38 35 33 39 38 2e 0a |quals 0,|785398..|
|00003e50| 0a 40 53 45 45 41 4c 53 | 4f 3d 54 41 4e 2c 20 43 |.@SEEALS|O=TAN, C|
|00003e60| 4f 53 2c 20 53 49 4e 2c | 20 44 45 47 52 45 45 53 |OS, SIN,| DEGREES|
|00003e70| 2c 20 52 41 44 49 41 4e | 53 00 40 46 55 4e 43 54 |, RADIAN|S.@FUNCT|
|00003e80| 49 4f 4e 3d 41 54 41 4e | 32 0a 40 53 59 4e 54 41 |ION=ATAN|2.@SYNTA|
|00003e90| 58 3d 41 54 41 4e 32 28 | 62 31 2c 62 32 29 0a 40 |X=ATAN2(|b1,b2).@|
|00003ea0| 44 45 53 43 52 49 50 54 | 49 4f 4e 3d 41 54 41 4e |DESCRIPT|ION=ATAN|
|00003eb0| 32 20 66 75 6e 63 74 69 | 6f 6e 20 63 61 6c 63 75 |2 functi|on calcu|
|00003ec0| 6c 61 74 65 73 20 74 68 | 65 20 61 72 63 20 74 61 |lates th|e arc ta|
|00003ed0| 6e 67 65 6e 74 20 6f 66 | 20 74 68 65 20 74 77 6f |ngent of| the two|
|00003ee0| 20 76 61 72 69 61 62 6c | 65 73 20 40 62 31 20 61 | variabl|es @b1 a|
|00003ef0| 6e 64 20 40 62 32 2e 20 | 20 49 74 20 69 73 20 73 |nd @b2. | It is s|
|00003f00| 69 6d 69 6c 61 72 20 74 | 6f 20 63 61 6c 63 75 6c |imilar t|o calcul|
|00003f10| 61 74 69 6e 67 20 74 68 | 65 20 61 72 63 20 74 61 |ating th|e arc ta|
|00003f20| 6e 67 65 6e 74 20 6f 66 | 20 40 62 32 20 2f 20 40 |ngent of| @b2 / @|
|00003f30| 62 31 2c 20 65 78 63 65 | 70 74 20 74 68 61 74 20 |b1, exce|pt that |
|00003f40| 74 68 65 20 73 69 67 6e | 73 20 6f 66 20 62 6f 74 |the sign|s of bot|
|00003f50| 68 20 61 72 67 75 6d 65 | 6e 74 73 20 61 72 65 20 |h argume|nts are |
|00003f60| 75 73 65 64 20 74 6f 20 | 64 65 74 65 72 6d 69 6e |used to |determin|
|00003f70| 65 20 74 68 65 20 71 75 | 61 64 72 61 6e 74 20 6f |e the qu|adrant o|
|00003f80| 66 20 74 68 65 20 72 65 | 73 75 6c 74 2e 0a 0a 2a |f the re|sult...*|
|00003f90| 20 54 68 65 20 72 65 73 | 75 6c 74 20 69 73 20 69 | The res|ult is i|
|00003fa0| 6e 20 72 61 64 69 61 6e | 73 2e 0a 2a 20 54 68 69 |n radian|s..* Thi|
|00003fb0| 73 20 66 75 6e 63 74 69 | 6f 6e 20 69 73 20 45 78 |s functi|on is Ex|
|00003fc0| 63 65 6c 20 63 6f 6d 70 | 61 74 69 62 6c 65 2e 0a |cel comp|atible..|
|00003fd0| 0a 40 45 58 41 4d 50 4c | 45 53 3d 0a 41 54 41 4e |.@EXAMPL|ES=.ATAN|
|00003fe0| 32 28 30 2e 35 2c 31 2e | 30 29 20 65 71 75 61 6c |2(0.5,1.|0) equal|
|00003ff0| 73 20 31 2e 31 30 37 31 | 34 39 2e 0a 41 54 41 4e |s 1.1071|49..ATAN|
|00004000| 32 28 2d 30 2e 35 2c 32 | 2e 30 29 20 65 71 75 61 |2(-0.5,2|.0) equa|
|00004010| 6c 73 20 31 2e 38 31 35 | 37 37 35 2e 0a 0a 40 53 |ls 1.815|775...@S|
|00004020| 45 45 41 4c 53 4f 3d 41 | 54 41 4e 2c 20 41 54 41 |EEALSO=A|TAN, ATA|
|00004030| 4e 48 2c 20 43 4f 53 2c | 20 53 49 4e 2c 20 44 45 |NH, COS,| SIN, DE|
|00004040| 47 52 45 45 53 2c 20 52 | 41 44 49 41 4e 53 00 40 |GREES, R|ADIANS.@|
|00004050| 46 55 4e 43 54 49 4f 4e | 3d 41 54 41 4e 48 0a 40 |FUNCTION|=ATANH.@|
|00004060| 53 59 4e 54 41 58 3d 41 | 54 41 4e 48 28 78 29 0a |SYNTAX=A|TANH(x).|
|00004070| 40 44 45 53 43 52 49 50 | 54 49 4f 4e 3d 41 54 41 |@DESCRIP|TION=ATA|
|00004080| 4e 48 20 66 75 6e 63 74 | 69 6f 6e 20 63 61 6c 63 |NH funct|ion calc|
|00004090| 75 6c 61 74 65 73 20 74 | 68 65 20 69 6e 76 65 72 |ulates t|he inver|
|000040a0| 73 65 20 68 79 70 65 72 | 62 6f 6c 69 63 20 74 61 |se hyper|bolic ta|
|000040b0| 6e 67 65 6e 74 20 6f 66 | 20 40 78 3b 20 74 68 61 |ngent of| @x; tha|
|000040c0| 74 20 69 73 20 74 68 65 | 20 76 61 6c 75 65 20 77 |t is the| value w|
|000040d0| 68 6f 73 65 20 68 79 70 | 65 72 62 6f 6c 69 63 20 |hose hyp|erbolic |
|000040e0| 74 61 6e 67 65 6e 74 20 | 69 73 20 40 78 2e 0a 0a |tangent |is @x...|
|000040f0| 2a 20 49 66 20 74 68 65 | 20 61 62 73 6f 6c 75 74 |* If the| absolut|
|00004100| 65 20 76 61 6c 75 65 20 | 6f 66 20 40 78 20 69 73 |e value |of @x is|
|00004110| 20 67 72 65 61 74 65 72 | 20 74 68 61 6e 20 31 2e | greater| than 1.|
|00004120| 30 2c 20 41 54 41 4e 48 | 20 72 65 74 75 72 6e 73 |0, ATANH| returns|
|00004130| 20 23 4e 55 4d 21 20 65 | 72 72 6f 72 2e 0a 2a 20 | #NUM! e|rror..* |
|00004140| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 69 73 |This fun|ction is|
|00004150| 20 45 78 63 65 6c 20 63 | 6f 6d 70 61 74 69 62 6c | Excel c|ompatibl|
|00004160| 65 2e 0a 0a 40 45 58 41 | 4d 50 4c 45 53 3d 0a 41 |e...@EXA|MPLES=.A|
|00004170| 54 41 4e 48 28 30 2e 35 | 29 20 65 71 75 61 6c 73 |TANH(0.5|) equals|
|00004180| 20 30 2e 35 34 39 33 30 | 36 2e 0a 41 54 41 4e 48 | 0.54930|6..ATANH|
|00004190| 28 30 2e 38 29 20 65 71 | 75 61 6c 73 20 31 2e 30 |(0.8) eq|uals 1.0|
|000041a0| 39 38 36 31 32 2e 0a 0a | 40 53 45 45 41 4c 53 4f |98612...|@SEEALSO|
|000041b0| 3d 41 54 41 4e 2c 20 54 | 41 4e 2c 20 53 49 4e 2c |=ATAN, T|AN, SIN,|
|000041c0| 20 43 4f 53 2c 20 44 45 | 47 52 45 45 53 2c 20 52 | COS, DE|GREES, R|
|000041d0| 41 44 49 41 4e 53 00 40 | 46 55 4e 43 54 49 4f 4e |ADIANS.@|FUNCTION|
|000041e0| 3d 41 56 45 44 45 56 0a | 40 53 59 4e 54 41 58 3d |=AVEDEV.|@SYNTAX=|
|000041f0| 41 56 45 44 45 56 28 6e | 31 2c 20 6e 32 2c 20 2e |AVEDEV(n|1, n2, .|
|00004200| 2e 2e 29 0a 40 44 45 53 | 43 52 49 50 54 49 4f 4e |..).@DES|CRIPTION|
|00004210| 3d 41 56 45 44 45 56 20 | 72 65 74 75 72 6e 73 20 |=AVEDEV |returns |
|00004220| 74 68 65 20 61 76 65 72 | 61 67 65 20 6f 66 20 74 |the aver|age of t|
|00004230| 68 65 20 61 62 73 6f 6c | 75 74 65 20 64 65 76 69 |he absol|ute devi|
|00004240| 61 74 69 6f 6e 73 20 6f | 66 20 61 20 64 61 74 61 |ations o|f a data|
|00004250| 20 73 65 74 20 66 72 6f | 6d 20 74 68 65 69 72 20 | set fro|m their |
|00004260| 6d 65 61 6e 2e 0a 0a 2a | 20 54 68 69 73 20 66 75 |mean...*| This fu|
|00004270| 6e 63 74 69 6f 6e 20 69 | 73 20 45 78 63 65 6c 20 |nction i|s Excel |
|00004280| 63 6f 6d 70 61 74 69 62 | 6c 65 2e 0a 0a 40 45 58 |compatib|le...@EX|
|00004290| 41 4d 50 4c 45 53 3d 0a | 4c 65 74 20 75 73 20 61 |AMPLES=.|Let us a|
|000042a0| 73 73 75 6d 65 20 74 68 | 61 74 20 74 68 65 20 63 |ssume th|at the c|
|000042b0| 65 6c 6c 73 20 41 31 2c | 20 41 32 2c 20 2e 2e 2e |ells A1,| A2, ...|
|000042c0| 2c 20 41 35 20 63 6f 6e | 74 61 69 6e 20 6e 75 6d |, A5 con|tain num|
|000042d0| 62 65 72 73 20 31 31 2e | 34 2c 20 31 37 2e 33 2c |bers 11.|4, 17.3,|
|000042e0| 20 32 31 2e 33 2c 20 32 | 35 2e 39 2c 20 61 6e 64 | 21.3, 2|5.9, and|
|000042f0| 20 34 30 2e 31 2e 20 20 | 54 68 65 6e 0a 41 56 45 | 40.1.  |Then.AVE|
|00004300| 44 45 56 28 41 31 3a 41 | 35 29 20 65 71 75 61 6c |DEV(A1:A|5) equal|
|00004310| 73 20 37 2e 38 34 2e 0a | 0a 40 53 45 45 41 4c 53 |s 7.84..|.@SEEALS|
|00004320| 4f 3d 53 54 44 45 56 00 | 40 46 55 4e 43 54 49 4f |O=STDEV.|@FUNCTIO|
|00004330| 4e 3d 41 56 45 52 41 47 | 45 0a 40 53 59 4e 54 41 |N=AVERAG|E.@SYNTA|
|00004340| 58 3d 41 56 45 52 41 47 | 45 28 76 61 6c 75 65 31 |X=AVERAG|E(value1|
|00004350| 2c 20 76 61 6c 75 65 32 | 2c 2e 2e 2e 29 0a 40 44 |, value2|,...).@D|
|00004360| 45 53 43 52 49 50 54 49 | 4f 4e 3d 41 56 45 52 41 |ESCRIPTI|ON=AVERA|
|00004370| 47 45 20 63 6f 6d 70 75 | 74 65 73 20 74 68 65 20 |GE compu|tes the |
|00004380| 61 76 65 72 61 67 65 20 | 6f 66 20 61 6c 6c 20 74 |average |of all t|
|00004390| 68 65 20 76 61 6c 75 65 | 73 20 61 6e 64 20 63 65 |he value|s and ce|
|000043a0| 6c 6c 73 20 72 65 66 65 | 72 65 6e 63 65 64 20 69 |lls refe|renced i|
|000043b0| 6e 20 74 68 65 20 61 72 | 67 75 6d 65 6e 74 20 6c |n the ar|gument l|
|000043c0| 69 73 74 2e 20 20 54 68 | 69 73 20 69 73 20 65 71 |ist.  Th|is is eq|
|000043d0| 75 69 76 61 6c 65 6e 74 | 20 74 6f 20 74 68 65 20 |uivalent| to the |
|000043e0| 73 75 6d 20 6f 66 20 74 | 68 65 20 61 72 67 75 6d |sum of t|he argum|
|000043f0| 65 6e 74 73 20 64 69 76 | 69 64 65 64 20 62 79 20 |ents div|ided by |
|00004400| 74 68 65 20 63 6f 75 6e | 74 20 6f 66 20 74 68 65 |the coun|t of the|
|00004410| 20 61 72 67 75 6d 65 6e | 74 73 2e 0a 0a 2a 20 54 | argumen|ts...* T|
|00004420| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 69 73 20 |his func|tion is |
|00004430| 45 78 63 65 6c 20 63 6f | 6d 70 61 74 69 62 6c 65 |Excel co|mpatible|
|00004440| 2e 0a 0a 40 45 58 41 4d | 50 4c 45 53 3d 0a 4c 65 |...@EXAM|PLES=.Le|
|00004450| 74 20 75 73 20 61 73 73 | 75 6d 65 20 74 68 61 74 |t us ass|ume that|
|00004460| 20 74 68 65 20 63 65 6c | 6c 73 20 41 31 2c 20 41 | the cel|ls A1, A|
|00004470| 32 2c 20 2e 2e 2e 2c 20 | 41 35 20 63 6f 6e 74 61 |2, ..., |A5 conta|
|00004480| 69 6e 20 6e 75 6d 62 65 | 72 73 20 31 31 2e 34 2c |in numbe|rs 11.4,|
|00004490| 20 31 37 2e 33 2c 20 32 | 31 2e 33 2c 20 32 35 2e | 17.3, 2|1.3, 25.|
|000044a0| 39 2c 20 61 6e 64 20 34 | 30 2e 31 2e 20 20 54 68 |9, and 4|0.1.  Th|
|000044b0| 65 6e 0a 41 56 45 52 41 | 47 45 28 41 31 3a 41 35 |en.AVERA|GE(A1:A5|
|000044c0| 29 20 65 71 75 61 6c 73 | 20 32 33 2e 32 2e 0a 0a |) equals| 23.2...|
|000044d0| 40 53 45 45 41 4c 53 4f | 3d 53 55 4d 2c 20 43 4f |@SEEALSO|=SUM, CO|
|000044e0| 55 4e 54 00 40 46 55 4e | 43 54 49 4f 4e 3d 41 56 |UNT.@FUN|CTION=AV|
|000044f0| 45 52 41 47 45 41 0a 40 | 53 59 4e 54 41 58 3d 41 |ERAGEA.@|SYNTAX=A|
|00004500| 56 45 52 41 47 45 41 28 | 6e 75 6d 62 65 72 31 2c |VERAGEA(|number1,|
|00004510| 6e 75 6d 62 65 72 32 2c | 2e 2e 2e 29 0a 40 44 45 |number2,|...).@DE|
|00004520| 53 43 52 49 50 54 49 4f | 4e 3d 41 56 45 52 41 47 |SCRIPTIO|N=AVERAG|
|00004530| 45 41 20 72 65 74 75 72 | 6e 73 20 74 68 65 20 61 |EA retur|ns the a|
|00004540| 76 65 72 61 67 65 20 6f | 66 20 74 68 65 20 67 69 |verage o|f the gi|
|00004550| 76 65 6e 20 61 72 67 75 | 6d 65 6e 74 73 2e 20 20 |ven argu|ments.  |
|00004560| 4e 75 6d 62 65 72 73 2c | 20 74 65 78 74 20 61 6e |Numbers,| text an|
|00004570| 64 20 6c 6f 67 69 63 61 | 6c 20 76 61 6c 75 65 73 |d logica|l values|
|00004580| 20 61 72 65 20 69 6e 63 | 6c 75 64 65 64 20 69 6e | are inc|luded in|
|00004590| 20 74 68 65 20 63 61 6c | 63 75 6c 61 74 69 6f 6e | the cal|culation|
|000045a0| 20 74 6f 6f 2e 20 49 66 | 20 74 68 65 20 63 65 6c | too. If| the cel|
|000045b0| 6c 20 63 6f 6e 74 61 69 | 6e 73 20 74 65 78 74 20 |l contai|ns text |
|000045c0| 6f 72 20 74 68 65 20 61 | 72 67 75 6d 65 6e 74 20 |or the a|rgument |
|000045d0| 65 76 61 6c 75 61 74 65 | 73 20 74 6f 20 46 41 4c |evaluate|s to FAL|
|000045e0| 53 45 2c 20 69 74 20 69 | 73 20 63 6f 75 6e 74 65 |SE, it i|s counte|
|000045f0| 64 20 61 73 20 76 61 6c | 75 65 20 7a 65 72 6f 20 |d as val|ue zero |
|00004600| 28 30 29 2e 20 20 49 66 | 20 74 68 65 20 61 72 67 |(0).  If| the arg|
|00004610| 75 6d 65 6e 74 20 65 76 | 61 6c 75 61 74 65 73 20 |ument ev|aluates |
|00004620| 74 6f 20 54 52 55 45 2c | 20 69 74 20 69 73 20 63 |to TRUE,| it is c|
|00004630| 6f 75 6e 74 65 64 20 61 | 73 20 6f 6e 65 20 28 31 |ounted a|s one (1|
|00004640| 29 2e 20 20 4e 6f 74 65 | 20 74 68 61 74 20 65 6d |).  Note| that em|
|00004650| 70 74 79 20 63 65 6c 6c | 73 20 61 72 65 20 6e 6f |pty cell|s are no|
|00004660| 74 20 63 6f 75 6e 74 65 | 64 2e 0a 0a 2a 20 54 68 |t counte|d...* Th|
|00004670| 69 73 20 66 75 6e 63 74 | 69 6f 6e 20 69 73 20 45 |is funct|ion is E|
|00004680| 78 63 65 6c 20 63 6f 6d | 70 61 74 69 62 6c 65 2e |xcel com|patible.|
|00004690| 0a 0a 40 45 58 41 4d 50 | 4c 45 53 3d 0a 4c 65 74 |..@EXAMP|LES=.Let|
|000046a0| 20 75 73 20 61 73 73 75 | 6d 65 20 74 68 61 74 20 | us assu|me that |
|000046b0| 74 68 65 20 63 65 6c 6c | 73 20 41 31 2c 20 41 32 |the cell|s A1, A2|
|000046c0| 2c 20 2e 2e 2e 2c 20 41 | 35 20 63 6f 6e 74 61 69 |, ..., A|5 contai|
|000046d0| 6e 20 6e 75 6d 62 65 72 | 73 20 61 6e 64 20 73 74 |n number|s and st|
|000046e0| 72 69 6e 67 73 20 31 31 | 2e 34 2c 20 31 37 2e 33 |rings 11|.4, 17.3|
|000046f0| 2c 20 22 6d 69 73 73 69 | 6e 67 22 2c 20 32 35 2e |, "missi|ng", 25.|
|00004700| 39 2c 20 61 6e 64 20 34 | 30 2e 31 2e 20 20 54 68 |9, and 4|0.1.  Th|
|00004710| 65 6e 0a 41 56 45 52 41 | 47 45 41 28 41 31 3a 41 |en.AVERA|GEA(A1:A|
|00004720| 35 29 20 65 71 75 61 6c | 73 20 31 38 2e 39 34 2e |5) equal|s 18.94.|
|00004730| 0a 0a 40 53 45 45 41 4c | 53 4f 3d 41 56 45 52 41 |..@SEEAL|SO=AVERA|
|00004740| 47 45 00 40 46 55 4e 43 | 54 49 4f 4e 3d 42 41 53 |GE.@FUNC|TION=BAS|
|00004750| 45 0a 40 53 59 4e 54 41 | 58 3d 42 41 53 45 28 6e |E.@SYNTA|X=BASE(n|
|00004760| 75 6d 62 65 72 2c 62 61 | 73 65 5b 2c 6c 65 6e 67 |umber,ba|se[,leng|
|00004770| 74 68 5d 29 0a 40 44 45 | 53 43 52 49 50 54 49 4f |th]).@DE|SCRIPTIO|
|00004780| 4e 3d 42 41 53 45 20 66 | 75 6e 63 74 69 6f 6e 20 |N=BASE f|unction |
|00004790| 63 6f 6e 76 65 72 74 73 | 20 61 20 6e 75 6d 62 65 |converts| a numbe|
|000047a0| 72 20 74 6f 20 61 20 73 | 74 72 69 6e 67 20 72 65 |r to a s|tring re|
|000047b0| 70 72 65 73 65 6e 74 69 | 6e 67 20 74 68 61 74 20 |presenti|ng that |
|000047c0| 6e 75 6d 62 65 72 20 69 | 6e 20 62 61 73 65 20 40 |number i|n base @|
|000047d0| 62 61 73 65 2e 0a 0a 2a | 20 40 62 61 73 65 20 6d |base...*| @base m|
|000047e0| 75 73 74 20 62 65 20 61 | 6e 20 69 6e 74 65 67 65 |ust be a|n intege|
|000047f0| 72 20 62 65 74 77 65 65 | 6e 20 32 20 61 6e 64 20 |r betwee|n 2 and |
|00004800| 33 36 2e 0a 2a 20 54 68 | 69 73 20 66 75 6e 63 74 |36..* Th|is funct|
|00004810| 69 6f 6e 20 69 73 20 4f | 70 65 6e 4f 66 66 69 63 |ion is O|penOffic|
|00004820| 65 2e 4f 72 67 20 63 6f | 6d 70 61 74 69 62 6c 65 |e.Org co|mpatible|
|00004830| 2e 0a 2a 20 4f 70 74 69 | 6f 6e 61 6c 20 61 72 67 |..* Opti|onal arg|
|00004840| 75 6d 65 6e 74 20 40 6c | 65 6e 67 74 68 20 73 70 |ument @l|ength sp|
|00004850| 65 63 69 66 69 65 73 20 | 74 68 65 20 6d 69 6e 69 |ecifies |the mini|
|00004860| 6d 75 6d 20 72 65 73 75 | 6c 74 20 6c 65 6e 67 74 |mum resu|lt lengt|
|00004870| 68 2e 20 20 4c 65 61 64 | 69 6e 67 20 20 7a 65 72 |h.  Lead|ing  zer|
|00004880| 6f 65 73 20 77 69 6c 6c | 20 62 65 20 61 64 64 65 |oes will| be adde|
|00004890| 64 20 74 6f 20 72 65 61 | 63 68 20 74 68 69 73 20 |d to rea|ch this |
|000048a0| 6c 65 6e 67 74 68 2e 0a | 0a 40 45 58 41 4d 50 4c |length..|.@EXAMPL|
|000048b0| 45 53 3d 0a 42 41 53 45 | 28 32 35 35 2c 31 36 2c |ES=.BASE|(255,16,|
|000048c0| 34 29 20 65 71 75 61 6c | 73 20 22 30 30 46 46 22 |4) equal|s "00FF"|
|000048d0| 2e 0a 0a 40 53 45 45 41 | 4c 53 4f 3d 44 45 43 49 |...@SEEA|LSO=DECI|
|000048e0| 4d 41 4c 00 40 46 55 4e | 43 54 49 4f 4e 3d 42 45 |MAL.@FUN|CTION=BE|
|000048f0| 52 4e 4f 55 4c 4c 49 0a | 40 53 59 4e 54 41 58 3d |RNOULLI.|@SYNTAX=|
|00004900| 42 45 52 4e 4f 55 4c 4c | 49 28 6b 2c 70 29 0a 40 |BERNOULL|I(k,p).@|
|00004910| 44 45 53 43 52 49 50 54 | 49 4f 4e 3d 42 45 52 4e |DESCRIPT|ION=BERN|
|00004920| 4f 55 4c 4c 49 20 72 65 | 74 75 72 6e 73 20 74 68 |OULLI re|turns th|
|00004930| 65 20 70 72 6f 62 61 62 | 69 6c 69 74 79 20 70 28 |e probab|ility p(|
|00004940| 6b 29 20 6f 66 20 6f 62 | 74 61 69 6e 69 6e 67 20 |k) of ob|taining |
|00004950| 40 6b 20 66 72 6f 6d 20 | 61 20 42 65 72 6e 6f 75 |@k from |a Bernou|
|00004960| 6c 6c 69 20 64 69 73 74 | 72 69 62 75 74 69 6f 6e |lli dist|ribution|
|00004970| 20 77 69 74 68 20 70 72 | 6f 62 61 62 69 6c 69 74 | with pr|obabilit|
|00004980| 79 20 70 61 72 61 6d 65 | 74 65 72 20 40 70 2e 0a |y parame|ter @p..|
|00004990| 0a 2a 20 49 66 20 40 6b | 20 21 3d 20 30 20 61 6e |.* If @k| != 0 an|
|000049a0| 64 20 40 6b 20 21 3d 20 | 31 20 42 45 52 4e 4f 55 |d @k != |1 BERNOU|
|000049b0| 4c 4c 49 20 72 65 74 75 | 72 6e 73 20 23 4e 55 4d |LLI retu|rns #NUM|
|000049c0| 21 20 65 72 72 6f 72 2e | 0a 2a 20 49 66 20 40 70 |! error.|.* If @p|
|000049d0| 20 3c 20 30 20 6f 72 20 | 40 70 20 3e 20 31 20 42 | < 0 or |@p > 1 B|
|000049e0| 45 52 4e 4f 55 4c 4c 49 | 20 72 65 74 75 72 6e 73 |ERNOULLI| returns|
|000049f0| 20 23 4e 55 4d 21 20 65 | 72 72 6f 72 2e 0a 0a 40 | #NUM! e|rror...@|
|00004a00| 45 58 41 4d 50 4c 45 53 | 3d 0a 42 45 52 4e 4f 55 |EXAMPLES|=.BERNOU|
|00004a10| 4c 4c 49 28 30 2c 30 2e | 35 29 2e 0a 0a 40 53 45 |LLI(0,0.|5)...@SE|
|00004a20| 45 41 4c 53 4f 3d 52 41 | 4e 44 42 45 52 4e 4f 55 |EALSO=RA|NDBERNOU|
|00004a30| 4c 4c 49 00 40 46 55 4e | 43 54 49 4f 4e 3d 42 45 |LLI.@FUN|CTION=BE|
|00004a40| 53 53 45 4c 4a 0a 40 53 | 59 4e 54 41 58 3d 42 45 |SSELJ.@S|YNTAX=BE|
|00004a50| 53 53 45 4c 4a 28 78 2c | 79 29 0a 40 44 45 53 43 |SSELJ(x,|y).@DESC|
|00004a60| 52 49 50 54 49 4f 4e 3d | 42 45 53 53 45 4c 4a 20 |RIPTION=|BESSELJ |
|00004a70| 66 75 6e 63 74 69 6f 6e | 20 72 65 74 75 72 6e 73 |function| returns|
|00004a80| 20 74 68 65 20 42 65 73 | 73 65 6c 20 66 75 6e 63 | the Bes|sel func|
|00004a90| 74 69 6f 6e 20 77 69 74 | 68 20 40 78 20 69 73 20 |tion wit|h @x is |
|00004aa0| 77 68 65 72 65 20 74 68 | 65 20 66 75 6e 63 74 69 |where th|e functi|
|00004ab0| 6f 6e 20 69 73 20 65 76 | 61 6c 75 61 74 65 64 2e |on is ev|aluated.|
|00004ac0| 20 40 79 20 69 73 20 74 | 68 65 20 6f 72 64 65 72 | @y is t|he order|
|00004ad0| 20 6f 66 20 74 68 65 20 | 42 65 73 73 65 6c 20 66 | of the |Bessel f|
|00004ae0| 75 6e 63 74 69 6f 6e 2c | 20 69 66 20 6e 6f 6e 2d |unction,| if non-|
|00004af0| 69 6e 74 65 67 65 72 20 | 69 74 20 69 73 20 74 72 |integer |it is tr|
|00004b00| 75 6e 63 61 74 65 64 2e | 0a 0a 2a 20 49 66 20 40 |uncated.|..* If @|
|00004b10| 78 20 6f 72 20 40 79 20 | 61 72 65 20 6e 6f 74 20 |x or @y |are not |
|00004b20| 6e 75 6d 65 72 69 63 20 | 61 20 23 56 41 4c 55 45 |numeric |a #VALUE|
|00004b30| 21 20 65 72 72 6f 72 20 | 69 73 20 72 65 74 75 72 |! error |is retur|
|00004b40| 6e 65 64 2e 0a 2a 20 49 | 66 20 40 79 20 3c 20 30 |ned..* I|f @y < 0|
|00004b50| 20 61 20 23 4e 55 4d 21 | 20 65 72 72 6f 72 20 69 | a #NUM!| error i|
|00004b60| 73 20 72 65 74 75 72 6e | 65 64 2e 0a 2a 20 54 68 |s return|ed..* Th|
|00004b70| 69 73 20 66 75 6e 63 74 | 69 6f 6e 20 69 73 20 45 |is funct|ion is E|
|00004b80| 78 63 65 6c 20 63 6f 6d | 70 61 74 69 62 6c 65 2e |xcel com|patible.|
|00004b90| 0a 0a 40 45 58 41 4d 50 | 4c 45 53 3d 0a 42 45 53 |..@EXAMP|LES=.BES|
|00004ba0| 53 45 4c 4a 28 30 2e 38 | 39 2c 33 29 20 65 71 75 |SELJ(0.8|9,3) equ|
|00004bb0| 61 6c 73 20 30 2e 30 31 | 33 39 37 34 30 30 34 2e |als 0.01|3974004.|
|00004bc0| 0a 0a 40 53 45 45 41 4c | 53 4f 3d 42 45 53 53 45 |..@SEEAL|SO=BESSE|
|00004bd0| 4c 49 2c 42 45 53 53 45 | 4c 4b 2c 42 45 53 53 45 |LI,BESSE|LK,BESSE|
|00004be0| 4c 59 00 40 46 55 4e 43 | 54 49 4f 4e 3d 42 45 53 |LY.@FUNC|TION=BES|
|00004bf0| 53 45 4c 59 0a 40 53 59 | 4e 54 41 58 3d 42 45 53 |SELY.@SY|NTAX=BES|
|00004c00| 53 45 4c 59 28 78 2c 79 | 29 0a 40 44 45 53 43 52 |SELY(x,y|).@DESCR|
|00004c10| 49 50 54 49 4f 4e 3d 42 | 45 53 53 45 4c 59 20 66 |IPTION=B|ESSELY f|
|00004c20| 75 6e 63 74 69 6f 6e 20 | 72 65 74 75 72 6e 73 20 |unction |returns |
|00004c30| 74 68 65 20 4e 65 75 6d | 61 6e 6e 2c 20 57 65 62 |the Neum|ann, Web|
|00004c40| 65 72 20 6f 72 20 42 65 | 73 73 65 6c 20 66 75 6e |er or Be|ssel fun|
|00004c50| 63 74 69 6f 6e 2e 0a 0a | 40 78 20 69 73 20 77 68 |ction...|@x is wh|
|00004c60| 65 72 65 20 74 68 65 20 | 66 75 6e 63 74 69 6f 6e |ere the |function|
|00004c70| 20 69 73 20 65 76 61 6c | 75 61 74 65 64 2e 20 40 | is eval|uated. @|
|00004c80| 79 20 69 73 20 74 68 65 | 20 6f 72 64 65 72 20 6f |y is the| order o|
|00004c90| 66 20 74 68 65 20 42 65 | 73 73 65 6c 20 66 75 6e |f the Be|ssel fun|
|00004ca0| 63 74 69 6f 6e 2c 20 69 | 66 20 6e 6f 6e 2d 69 6e |ction, i|f non-in|
|00004cb0| 74 65 67 65 72 20 69 74 | 20 69 73 20 74 72 75 6e |teger it| is trun|
|00004cc0| 63 61 74 65 64 2e 0a 0a | 2a 20 49 66 20 40 78 20 |cated...|* If @x |
|00004cd0| 6f 72 20 40 79 20 61 72 | 65 20 6e 6f 74 20 6e 75 |or @y ar|e not nu|
|00004ce0| 6d 65 72 69 63 20 61 20 | 23 56 41 4c 55 45 21 20 |meric a |#VALUE! |
|00004cf0| 65 72 72 6f 72 20 69 73 | 20 72 65 74 75 72 6e 65 |error is| returne|
|00004d00| 64 2e 0a 2a 20 49 66 20 | 40 79 20 3c 20 30 20 61 |d..* If |@y < 0 a|
|00004d10| 20 23 4e 55 4d 21 20 65 | 72 72 6f 72 20 69 73 20 | #NUM! e|rror is |
|00004d20| 72 65 74 75 72 6e 65 64 | 2e 0a 2a 20 54 68 69 73 |returned|..* This|
|00004d30| 20 66 75 6e 63 74 69 6f | 6e 20 69 73 20 45 78 63 | functio|n is Exc|
|00004d40| 65 6c 20 63 6f 6d 70 61 | 74 69 62 6c 65 2e 0a 0a |el compa|tible...|
|00004d50| 40 45 58 41 4d 50 4c 45 | 53 3d 0a 42 45 53 53 45 |@EXAMPLE|S=.BESSE|
|00004d60| 4c 59 28 34 2c 32 29 20 | 65 71 75 61 6c 73 20 30 |LY(4,2) |equals 0|
|00004d70| 2e 32 31 35 39 30 33 35 | 39 35 2e 0a 0a 40 53 45 |.2159035|95...@SE|
|00004d80| 45 41 4c 53 4f 3d 42 45 | 53 53 45 4c 49 2c 42 45 |EALSO=BE|SSELI,BE|
|00004d90| 53 53 45 4c 4a 2c 42 45 | 53 53 45 4c 4b 00 40 46 |SSELJ,BE|SSELK.@F|
|00004da0| 55 4e 43 54 49 4f 4e 3d | 42 45 54 41 44 49 53 54 |UNCTION=|BETADIST|
|00004db0| 0a 40 53 59 4e 54 41 58 | 3d 42 45 54 41 44 49 53 |.@SYNTAX|=BETADIS|
|00004dc0| 54 28 78 2c 61 6c 70 68 | 61 2c 62 65 74 61 5b 2c |T(x,alph|a,beta[,|
|00004dd0| 61 2c 62 5d 29 0a 40 44 | 45 53 43 52 49 50 54 49 |a,b]).@D|ESCRIPTI|
|00004de0| 4f 4e 3d 42 45 54 41 44 | 49 53 54 20 66 75 6e 63 |ON=BETAD|IST func|
|00004df0| 74 69 6f 6e 20 72 65 74 | 75 72 6e 73 20 74 68 65 |tion ret|urns the|
|00004e00| 20 63 75 6d 75 6c 61 74 | 69 76 65 20 62 65 74 61 | cumulat|ive beta|
|00004e10| 20 64 69 73 74 72 69 62 | 75 74 69 6f 6e 2e 20 40 | distrib|ution. @|
|00004e20| 61 20 69 73 20 74 68 65 | 20 6f 70 74 69 6f 6e 61 |a is the| optiona|
|00004e30| 6c 20 6c 6f 77 65 72 20 | 62 6f 75 6e 64 20 6f 66 |l lower |bound of|
|00004e40| 20 40 78 20 61 6e 64 20 | 40 62 20 69 73 20 74 68 | @x and |@b is th|
|00004e50| 65 20 6f 70 74 69 6f 6e | 61 6c 20 75 70 70 65 72 |e option|al upper|
|00004e60| 20 62 6f 75 6e 64 20 6f | 66 20 40 78 2e 0a 2a 20 | bound o|f @x..* |
|00004e70| 49 66 20 40 61 20 69 73 | 20 6e 6f 74 20 67 69 76 |If @a is| not giv|
|00004e80| 65 6e 2c 20 42 45 54 41 | 44 49 53 54 20 75 73 65 |en, BETA|DIST use|
|00004e90| 73 20 30 2e 0a 2a 20 49 | 66 20 40 62 20 69 73 20 |s 0..* I|f @b is |
|00004ea0| 6e 6f 74 20 67 69 76 65 | 6e 2c 20 42 45 54 41 44 |not give|n, BETAD|
|00004eb0| 49 53 54 20 75 73 65 73 | 20 31 2e 0a 2a 20 49 66 |IST uses| 1..* If|
|00004ec0| 20 40 78 20 3c 20 40 61 | 20 6f 72 20 40 78 20 3e | @x < @a| or @x >|
|00004ed0| 20 40 62 20 42 45 54 41 | 44 49 53 54 20 72 65 74 | @b BETA|DIST ret|
|00004ee0| 75 72 6e 73 20 23 4e 55 | 4d 21 20 65 72 72 6f 72 |urns #NU|M! error|
|00004ef0| 2e 0a 2a 20 49 66 20 40 | 61 6c 70 68 61 20 3c 3d |..* If @|alpha <=|
|00004f00| 20 30 20 6f 72 20 40 62 | 65 74 61 20 3c 3d 20 30 | 0 or @b|eta <= 0|
|00004f10| 2c 20 42 45 54 41 44 49 | 53 54 20 72 65 74 75 72 |, BETADI|ST retur|
|00004f20| 6e 73 20 23 4e 55 4d 21 | 20 65 72 72 6f 72 2e 0a |ns #NUM!| error..|
|00004f30| 2a 20 49 66 20 40 61 20 | 3e 3d 20 40 62 20 42 45 |* If @a |>= @b BE|
|00004f40| 54 41 44 49 53 54 20 72 | 65 74 75 72 6e 73 20 23 |TADIST r|eturns #|
|00004f50| 4e 55 4d 21 20 65 72 72 | 6f 72 2e 0a 2a 20 54 68 |NUM! err|or..* Th|
|00004f60| 69 73 20 66 75 6e 63 74 | 69 6f 6e 20 69 73 20 45 |is funct|ion is E|
|00004f70| 78 63 65 6c 20 63 6f 6d | 70 61 74 69 62 6c 65 2e |xcel com|patible.|
|00004f80| 0a 0a 40 45 58 41 4d 50 | 4c 45 53 3d 0a 42 45 54 |..@EXAMP|LES=.BET|
|00004f90| 41 44 49 53 54 28 30 2e | 31 32 2c 32 2c 33 29 20 |ADIST(0.|12,2,3) |
|00004fa0| 65 71 75 61 6c 73 20 30 | 2e 30 37 33 31 39 38 30 |equals 0|.0731980|
|00004fb0| 38 2e 0a 0a 40 53 45 45 | 41 4c 53 4f 3d 42 45 54 |8...@SEE|ALSO=BET|
|00004fc0| 41 49 4e 56 00 40 46 55 | 4e 43 54 49 4f 4e 3d 42 |AINV.@FU|NCTION=B|
|00004fd0| 45 54 41 49 4e 56 0a 40 | 53 59 4e 54 41 58 3d 42 |ETAINV.@|SYNTAX=B|
|00004fe0| 45 54 41 49 4e 56 28 70 | 2c 61 6c 70 68 61 2c 62 |ETAINV(p|,alpha,b|
|00004ff0| 65 74 61 5b 2c 61 2c 62 | 5d 29 0a 40 44 45 53 43 |eta[,a,b|]).@DESC|
|00005000| 52 49 50 54 49 4f 4e 3d | 42 45 54 41 49 4e 56 20 |RIPTION=|BETAINV |
|00005010| 66 75 6e 63 74 69 6f 6e | 20 72 65 74 75 72 6e 73 |function| returns|
|00005020| 20 74 68 65 20 69 6e 76 | 65 72 73 65 20 6f 66 20 | the inv|erse of |
|00005030| 63 75 6d 75 6c 61 74 69 | 76 65 20 62 65 74 61 20 |cumulati|ve beta |
|00005040| 64 69 73 74 72 69 62 75 | 74 69 6f 6e 2e 20 20 40 |distribu|tion.  @|
|00005050| 61 20 69 73 20 74 68 65 | 20 6f 70 74 69 6f 6e 61 |a is the| optiona|
|00005060| 6c 20 6c 6f 77 65 72 20 | 62 6f 75 6e 64 20 6f 66 |l lower |bound of|
|00005070| 20 40 78 20 61 6e 64 20 | 40 62 20 69 73 20 74 68 | @x and |@b is th|
|00005080| 65 20 6f 70 74 69 6f 6e | 61 6c 20 75 70 70 65 72 |e option|al upper|
|00005090| 20 62 6f 75 6e 64 20 6f | 66 20 40 78 2e 0a 0a 2a | bound o|f @x...*|
|000050a0| 20 49 66 20 40 61 20 69 | 73 20 6e 6f 74 20 67 69 | If @a i|s not gi|
|000050b0| 76 65 6e 2c 20 42 45 54 | 41 49 4e 56 20 75 73 65 |ven, BET|AINV use|
|000050c0| 73 20 30 2e 0a 2a 20 49 | 66 20 40 62 20 69 73 20 |s 0..* I|f @b is |
|000050d0| 6e 6f 74 20 67 69 76 65 | 6e 2c 20 42 45 54 41 49 |not give|n, BETAI|
|000050e0| 4e 56 20 75 73 65 73 20 | 31 2e 0a 2a 20 49 66 20 |NV uses |1..* If |
|000050f0| 40 70 20 3c 20 30 20 6f | 72 20 40 70 20 3e 20 31 |@p < 0 o|r @p > 1|
|00005100| 20 42 45 54 41 49 4e 56 | 20 72 65 74 75 72 6e 73 | BETAINV| returns|
|00005110| 20 23 4e 55 4d 21 20 65 | 72 72 6f 72 2e 0a 2a 20 | #NUM! e|rror..* |
|00005120| 49 66 20 40 61 6c 70 68 | 61 20 3c 3d 20 30 20 6f |If @alph|a <= 0 o|
|00005130| 72 20 40 62 65 74 61 20 | 3c 3d 20 30 2c 20 42 45 |r @beta |<= 0, BE|
|00005140| 54 41 49 4e 56 20 72 65 | 74 75 72 6e 73 20 23 4e |TAINV re|turns #N|
|00005150| 55 4d 21 20 65 72 72 6f | 72 2e 0a 2a 20 49 66 20 |UM! erro|r..* If |
|00005160| 40 61 20 3e 3d 20 40 62 | 20 42 45 54 41 49 4e 56 |@a >= @b| BETAINV|
|00005170| 20 72 65 74 75 72 6e 73 | 20 23 4e 55 4d 21 20 65 | returns| #NUM! e|
|00005180| 72 72 6f 72 2e 0a 2a 20 | 54 68 69 73 20 66 75 6e |rror..* |This fun|
|00005190| 63 74 69 6f 6e 20 69 73 | 20 45 78 63 65 6c 20 63 |ction is| Excel c|
|000051a0| 6f 6d 70 61 74 69 62 6c | 65 2e 0a 0a 40 45 58 41 |ompatibl|e...@EXA|
|000051b0| 4d 50 4c 45 53 3d 0a 42 | 45 54 41 49 4e 56 28 30 |MPLES=.B|ETAINV(0|
|000051c0| 2e 34 35 2c 31 2e 36 2c | 31 29 20 65 71 75 61 6c |.45,1.6,|1) equal|
|000051d0| 73 20 30 2e 36 30 37 30 | 39 36 36 32 39 2e 0a 0a |s 0.6070|96629...|
|000051e0| 40 53 45 45 41 4c 53 4f | 3d 42 45 54 41 44 49 53 |@SEEALSO|=BETADIS|
|000051f0| 54 00 40 46 55 4e 43 54 | 49 4f 4e 3d 42 45 54 41 |T.@FUNCT|ION=BETA|
|00005200| 4c 4e 0a 40 53 59 4e 54 | 41 58 3d 42 45 54 41 4c |LN.@SYNT|AX=BETAL|
|00005210| 4e 28 61 2c 62 29 0a 40 | 44 45 53 43 52 49 50 54 |N(a,b).@|DESCRIPT|
|00005220| 49 4f 4e 3d 42 45 54 41 | 4c 4e 20 66 75 6e 63 74 |ION=BETA|LN funct|
|00005230| 69 6f 6e 20 72 65 74 75 | 72 6e 73 20 74 68 65 20 |ion retu|rns the |
|00005240| 6e 61 74 75 72 61 6c 20 | 6c 6f 67 61 72 69 74 68 |natural |logarith|
|00005250| 6d 20 6f 66 20 74 68 65 | 20 61 62 73 6f 6c 75 74 |m of the| absolut|
|00005260| 65 20 76 61 6c 75 65 20 | 6f 66 20 74 68 65 20 62 |e value |of the b|
|00005270| 65 74 61 20 66 75 6e 63 | 74 69 6f 6e 2e 0a 0a 2a |eta func|tion...*|
|00005280| 20 49 66 20 40 61 2c 20 | 40 62 2c 20 6f 72 20 28 | If @a, |@b, or (|
|00005290| 40 61 20 2b 20 40 62 29 | 20 61 72 65 20 6e 6f 6e |@a + @b)| are non|
|000052a0| 2d 70 6f 73 69 74 69 76 | 65 20 69 6e 74 65 67 65 |-positiv|e intege|
|000052b0| 72 73 2c 20 42 45 54 41 | 4c 4e 20 72 65 74 75 72 |rs, BETA|LN retur|
|000052c0| 6e 73 20 23 4e 55 4d 21 | 20 0a 40 45 58 41 4d 50 |ns #NUM!| .@EXAMP|
|000052d0| 4c 45 53 3d 0a 42 45 54 | 41 4c 4e 28 32 2c 33 29 |LES=.BET|ALN(2,3)|
|000052e0| 20 65 71 75 61 6c 73 20 | 2d 32 2e 34 38 2e 0a 42 | equals |-2.48..B|
|000052f0| 45 54 41 4c 4e 28 2d 30 | 2e 35 2c 30 2e 35 29 20 |ETALN(-0|.5,0.5) |
|00005300| 65 71 75 61 6c 73 20 23 | 4e 55 4d 21 2e 0a 0a 40 |equals #|NUM!...@|
|00005310| 53 45 45 41 4c 53 4f 3d | 42 45 54 41 2c 47 41 4d |SEEALSO=|BETA,GAM|
|00005320| 4d 41 4c 4e 00 40 46 55 | 4e 43 54 49 4f 4e 3d 42 |MALN.@FU|NCTION=B|
|00005330| 49 4e 32 44 45 43 0a 40 | 53 59 4e 54 41 58 3d 42 |IN2DEC.@|SYNTAX=B|
|00005340| 49 4e 32 44 45 43 28 78 | 29 0a 40 44 45 53 43 52 |IN2DEC(x|).@DESCR|
|00005350| 49 50 54 49 4f 4e 3d 42 | 49 4e 32 44 45 43 20 66 |IPTION=B|IN2DEC f|
|00005360| 75 6e 63 74 69 6f 6e 20 | 63 6f 6e 76 65 72 74 73 |unction |converts|
|00005370| 20 61 20 62 69 6e 61 72 | 79 20 6e 75 6d 62 65 72 | a binar|y number|
|00005380| 20 69 6e 20 73 74 72 69 | 6e 67 20 6f 72 20 6e 75 | in stri|ng or nu|
|00005390| 6d 62 65 72 20 74 6f 20 | 69 74 73 20 64 65 63 69 |mber to |its deci|
|000053a0| 6d 61 6c 20 65 71 75 69 | 76 61 6c 65 6e 74 2e 0a |mal equi|valent..|
|000053b0| 0a 2a 20 54 68 69 73 20 | 66 75 6e 63 74 69 6f 6e |.* This |function|
|000053c0| 20 69 73 20 45 78 63 65 | 6c 20 63 6f 6d 70 61 74 | is Exce|l compat|
|000053d0| 69 62 6c 65 2e 0a 0a 40 | 45 58 41 4d 50 4c 45 53 |ible...@|EXAMPLES|
|000053e0| 3d 0a 42 49 4e 32 44 45 | 43 28 31 30 31 29 20 65 |=.BIN2DE|C(101) e|
|000053f0| 71 75 61 6c 73 20 35 2e | 0a 0a 40 53 45 45 41 4c |quals 5.|..@SEEAL|
|00005400| 53 4f 3d 44 45 43 32 42 | 49 4e 2c 20 42 49 4e 32 |SO=DEC2B|IN, BIN2|
|00005410| 4f 43 54 2c 20 42 49 4e | 32 48 45 58 00 40 46 55 |OCT, BIN|2HEX.@FU|
|00005420| 4e 43 54 49 4f 4e 3d 42 | 49 4e 32 48 45 58 0a 40 |NCTION=B|IN2HEX.@|
|00005430| 53 59 4e 54 41 58 3d 42 | 49 4e 32 48 45 58 28 6e |SYNTAX=B|IN2HEX(n|
|00005440| 75 6d 62 65 72 5b 2c 70 | 6c 61 63 65 73 5d 29 0a |umber[,p|laces]).|
|00005450| 40 44 45 53 43 52 49 50 | 54 49 4f 4e 3d 42 49 4e |@DESCRIP|TION=BIN|
|00005460| 32 48 45 58 20 66 75 6e | 63 74 69 6f 6e 20 63 6f |2HEX fun|ction co|
|00005470| 6e 76 65 72 74 73 20 61 | 20 62 69 6e 61 72 79 20 |nverts a| binary |
|00005480| 6e 75 6d 62 65 72 20 74 | 6f 20 61 20 68 65 78 61 |number t|o a hexa|
|00005490| 64 65 63 69 6d 61 6c 20 | 6e 75 6d 62 65 72 2e 20 |decimal |number. |
|000054a0| 20 40 70 6c 61 63 65 73 | 20 69 73 20 61 6e 20 6f | @places| is an o|
|000054b0| 70 74 69 6f 6e 61 6c 20 | 66 69 65 6c 64 2c 20 73 |ptional |field, s|
|000054c0| 70 65 63 69 66 79 69 6e | 67 20 74 6f 20 7a 65 72 |pecifyin|g to zer|
|000054d0| 6f 20 70 61 64 20 74 6f | 20 74 68 61 74 20 6e 75 |o pad to| that nu|
|000054e0| 6d 62 65 72 20 6f 66 20 | 73 70 61 63 65 73 2e 0a |mber of |spaces..|
|000054f0| 0a 2a 20 49 66 20 40 70 | 6c 61 63 65 73 20 69 73 |.* If @p|laces is|
|00005500| 20 74 6f 6f 20 73 6d 61 | 6c 6c 20 6f 72 20 6e 65 | too sma|ll or ne|
|00005510| 67 61 74 69 76 65 20 23 | 4e 55 4d 21 20 65 72 72 |gative #|NUM! err|
|00005520| 6f 72 20 69 73 20 72 65 | 74 75 72 6e 65 64 2e 0a |or is re|turned..|
|00005530| 2a 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |* This f|unction |
|00005540| 69 73 20 45 78 63 65 6c | 20 63 6f 6d 70 61 74 69 |is Excel| compati|
|00005550| 62 6c 65 2e 0a 0a 40 45 | 58 41 4d 50 4c 45 53 3d |ble...@E|XAMPLES=|
|00005560| 0a 42 49 4e 32 48 45 58 | 28 31 30 30 31 31 31 29 |.BIN2HEX|(100111)|
|00005570| 20 65 71 75 61 6c 73 20 | 32 37 2e 0a 0a 40 53 45 | equals |27...@SE|
|00005580| 45 41 4c 53 4f 3d 48 45 | 58 32 42 49 4e 2c 20 42 |EALSO=HE|X2BIN, B|
|00005590| 49 4e 32 4f 43 54 2c 20 | 42 49 4e 32 44 45 43 00 |IN2OCT, |BIN2DEC.|
|000055a0| 40 46 55 4e 43 54 49 4f | 4e 3d 42 49 4e 32 4f 43 |@FUNCTIO|N=BIN2OC|
|000055b0| 54 0a 40 53 59 4e 54 41 | 58 3d 42 49 4e 32 4f 43 |T.@SYNTA|X=BIN2OC|
|000055c0| 54 28 6e 75 6d 62 65 72 | 5b 2c 70 6c 61 63 65 73 |T(number|[,places|
|000055d0| 5d 29 0a 40 44 45 53 43 | 52 49 50 54 49 4f 4e 3d |]).@DESC|RIPTION=|
|000055e0| 42 49 4e 32 4f 43 54 20 | 66 75 6e 63 74 69 6f 6e |BIN2OCT |function|
|000055f0| 20 63 6f 6e 76 65 72 74 | 73 20 61 20 62 69 6e 61 | convert|s a bina|
|00005600| 72 79 20 6e 75 6d 62 65 | 72 20 74 6f 20 61 6e 20 |ry numbe|r to an |
|00005610| 6f 63 74 61 6c 20 6e 75 | 6d 62 65 72 2e 20 40 70 |octal nu|mber. @p|
|00005620| 6c 61 63 65 73 20 69 73 | 20 61 6e 20 6f 70 74 69 |laces is| an opti|
|00005630| 6f 6e 61 6c 20 66 69 65 | 6c 64 2c 20 73 70 65 63 |onal fie|ld, spec|
|00005640| 69 66 79 69 6e 67 20 74 | 6f 20 7a 65 72 6f 20 70 |ifying t|o zero p|
|00005650| 61 64 20 74 6f 20 74 68 | 61 74 20 6e 75 6d 62 65 |ad to th|at numbe|
|00005660| 72 20 6f 66 20 73 70 61 | 63 65 73 2e 0a 0a 2a 20 |r of spa|ces...* |
|00005670| 49 66 20 40 70 6c 61 63 | 65 73 20 69 73 20 74 6f |If @plac|es is to|
|00005680| 6f 20 73 6d 61 6c 6c 20 | 6f 72 20 6e 65 67 61 74 |o small |or negat|
|00005690| 69 76 65 20 23 4e 55 4d | 21 20 65 72 72 6f 72 20 |ive #NUM|! error |
|000056a0| 69 73 20 72 65 74 75 72 | 6e 65 64 2e 0a 2a 20 54 |is retur|ned..* T|
|000056b0| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 69 73 20 |his func|tion is |
|000056c0| 45 78 63 65 6c 20 63 6f | 6d 70 61 74 69 62 6c 65 |Excel co|mpatible|
|000056d0| 2e 0a 0a 40 45 58 41 4d | 50 4c 45 53 3d 0a 42 49 |...@EXAM|PLES=.BI|
|000056e0| 4e 32 4f 43 54 28 31 31 | 30 31 31 31 29 20 65 71 |N2OCT(11|0111) eq|
|000056f0| 75 61 6c 73 20 36 37 2e | 0a 0a 40 53 45 45 41 4c |uals 67.|..@SEEAL|
|00005700| 53 4f 3d 4f 43 54 32 42 | 49 4e 2c 20 42 49 4e 32 |SO=OCT2B|IN, BIN2|
|00005710| 44 45 43 2c 20 42 49 4e | 32 48 45 58 00 40 46 55 |DEC, BIN|2HEX.@FU|
|00005720| 4e 43 54 49 4f 4e 3d 42 | 49 4e 4f 4d 44 49 53 54 |NCTION=B|INOMDIST|
|00005730| 0a 40 53 59 4e 54 41 58 | 3d 42 49 4e 4f 4d 44 49 |.@SYNTAX|=BINOMDI|
|00005740| 53 54 28 6e 2c 74 72 69 | 61 6c 73 2c 70 2c 63 75 |ST(n,tri|als,p,cu|
|00005750| 6d 75 6c 61 74 69 76 65 | 29 0a 40 44 45 53 43 52 |mulative|).@DESCR|
|00005760| 49 50 54 49 4f 4e 3d 42 | 49 4e 4f 4d 44 49 53 54 |IPTION=B|INOMDIST|
|00005770| 20 66 75 6e 63 74 69 6f | 6e 20 72 65 74 75 72 6e | functio|n return|
|00005780| 73 20 74 68 65 20 62 69 | 6e 6f 6d 69 61 6c 20 64 |s the bi|nomial d|
|00005790| 69 73 74 72 69 62 75 74 | 69 6f 6e 2e 20 40 6e 20 |istribut|ion. @n |
|000057a0| 69 73 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |is the n|umber of|
|000057b0| 20 73 75 63 63 65 73 73 | 65 73 2c 20 40 74 72 69 | success|es, @tri|
|000057c0| 61 6c 73 20 69 73 20 74 | 68 65 20 74 6f 74 61 6c |als is t|he total|
|000057d0| 20 6e 75 6d 62 65 72 20 | 6f 66 20 69 6e 64 65 70 | number |of indep|
|000057e0| 65 6e 64 65 6e 74 20 74 | 72 69 61 6c 73 2c 20 40 |endent t|rials, @|
|000057f0| 70 20 69 73 20 74 68 65 | 20 70 72 6f 62 61 62 69 |p is the| probabi|
|00005800| 6c 69 74 79 20 6f 66 20 | 73 75 63 63 65 73 73 20 |lity of |success |
|00005810| 69 6e 20 74 72 69 61 6c | 73 2c 20 61 6e 64 20 40 |in trial|s, and @|
|00005820| 63 75 6d 75 6c 61 74 69 | 76 65 20 64 65 73 63 72 |cumulati|ve descr|
|00005830| 69 62 65 73 20 77 68 65 | 74 68 65 72 20 74 6f 20 |ibes whe|ther to |
|00005840| 72 65 74 75 72 6e 20 74 | 68 65 20 73 75 6d 20 6f |return t|he sum o|
|00005850| 66 20 74 68 65 20 62 69 | 6e 6f 6d 69 61 6c 20 66 |f the bi|nomial f|
|00005860| 75 6e 63 74 69 6f 6e 20 | 66 72 6f 6d 20 30 20 74 |unction |from 0 t|
|00005870| 6f 20 40 6e 2e 0a 0a 2a | 20 49 66 20 40 6e 20 6f |o @n...*| If @n o|
|00005880| 72 20 40 74 72 69 61 6c | 73 20 61 72 65 20 6e 6f |r @trial|s are no|
|00005890| 6e 2d 69 6e 74 65 67 65 | 72 20 74 68 65 79 20 61 |n-intege|r they a|
|000058a0| 72 65 20 74 72 75 6e 63 | 61 74 65 64 2e 0a 2a 20 |re trunc|ated..* |
|000058b0| 49 66 20 40 6e 20 3c 20 | 30 20 6f 72 20 40 74 72 |If @n < |0 or @tr|
|000058c0| 69 61 6c 73 20 3c 20 30 | 20 42 49 4e 4f 4d 44 49 |ials < 0| BINOMDI|
|000058d0| 53 54 20 72 65 74 75 72 | 6e 73 20 23 4e 55 4d 21 |ST retur|ns #NUM!|
|000058e0| 20 65 72 72 6f 72 2e 0a | 2a 20 49 66 20 40 6e 20 | error..|* If @n |
|000058f0| 3e 20 40 74 72 69 61 6c | 73 20 42 49 4e 4f 4d 44 |> @trial|s BINOMD|
|00005900| 49 53 54 20 72 65 74 75 | 72 6e 73 20 23 4e 55 4d |IST retu|rns #NUM|
|00005910| 21 20 65 72 72 6f 72 2e | 0a 2a 20 49 66 20 40 70 |! error.|.* If @p|
|00005920| 20 3c 20 30 20 6f 72 20 | 40 70 20 3e 20 31 20 42 | < 0 or |@p > 1 B|
|00005930| 49 4e 4f 4d 44 49 53 54 | 20 72 65 74 75 72 6e 73 |INOMDIST| returns|
|00005940| 20 23 4e 55 4d 21 20 65 | 72 72 6f 72 2e 0a 2a 20 | #NUM! e|rror..* |
|00005950| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 69 73 |This fun|ction is|
|00005960| 20 45 78 63 65 6c 20 63 | 6f 6d 70 61 74 69 62 6c | Excel c|ompatibl|
|00005970| 65 2e 0a 0a 40 45 58 41 | 4d 50 4c 45 53 3d 0a 42 |e...@EXA|MPLES=.B|
|00005980| 49 4e 4f 4d 44 49 53 54 | 28 33 2c 35 2c 30 2e 38 |INOMDIST|(3,5,0.8|
|00005990| 2c 30 29 20 65 71 75 61 | 6c 73 20 30 2e 32 30 34 |,0) equa|ls 0.204|
|000059a0| 38 2e 0a 0a 40 53 45 45 | 41 4c 53 4f 3d 50 4f 49 |8...@SEE|ALSO=POI|
|000059b0| 53 53 4f 4e 00 40 46 55 | 4e 43 54 49 4f 4e 3d 42 |SSON.@FU|NCTION=B|
|000059c0| 49 54 41 4e 44 0a 40 53 | 59 4e 54 41 58 3d 42 49 |ITAND.@S|YNTAX=BI|
|000059d0| 54 41 4e 44 28 61 2c 62 | 29 0a 40 44 45 53 43 52 |TAND(a,b|).@DESCR|
|000059e0| 49 50 54 49 4f 4e 3d 42 | 49 54 41 4e 44 20 66 75 |IPTION=B|ITAND fu|
|000059f0| 6e 63 74 69 6f 6e 20 72 | 65 74 75 72 6e 73 20 62 |nction r|eturns b|
|00005a00| 69 74 77 69 73 65 20 61 | 6e 64 2d 69 6e 67 20 6f |itwise a|nd-ing o|
|00005a10| 66 20 69 74 73 20 61 72 | 67 75 6d 65 6e 74 73 2e |f its ar|guments.|
|00005a20| 0a 0a 40 45 58 41 4d 50 | 4c 45 53 3d 0a 40 53 45 |..@EXAMP|LES=.@SE|
|00005a30| 45 41 4c 53 4f 3d 42 49 | 54 4f 52 2c 42 49 54 58 |EALSO=BI|TOR,BITX|
|00005a40| 4f 52 00 40 46 55 4e 43 | 54 49 4f 4e 3d 42 49 54 |OR.@FUNC|TION=BIT|
|00005a50| 4c 53 48 49 46 54 0a 40 | 53 59 4e 54 41 58 3d 42 |LSHIFT.@|SYNTAX=B|
|00005a60| 49 54 4c 53 48 49 46 54 | 28 78 2c 6e 29 0a 40 44 |ITLSHIFT|(x,n).@D|
|00005a70| 45 53 43 52 49 50 54 49 | 4f 4e 3d 42 49 54 4c 53 |ESCRIPTI|ON=BITLS|
|00005a80| 48 49 46 54 20 66 75 6e | 63 74 69 6f 6e 20 72 65 |HIFT fun|ction re|
|00005a90| 74 75 72 6e 73 20 40 78 | 20 62 69 74 2d 73 68 69 |turns @x| bit-shi|
|00005aa0| 66 74 65 64 20 6c 65 66 | 74 20 62 79 20 40 6e 20 |fted lef|t by @n |
|00005ab0| 62 69 74 73 2e 0a 0a 2a | 20 49 66 20 40 6e 20 69 |bits...*| If @n i|
|00005ac0| 73 20 6e 65 67 61 74 69 | 76 65 2c 20 61 20 72 69 |s negati|ve, a ri|
|00005ad0| 67 68 74 20 73 68 69 66 | 74 20 77 69 6c 6c 20 69 |ght shif|t will i|
|00005ae0| 6e 20 65 66 66 65 63 74 | 20 62 65 20 70 65 72 66 |n effect| be perf|
|00005af0| 6f 72 6d 65 64 2e 0a 0a | 40 45 58 41 4d 50 4c 45 |ormed...|@EXAMPLE|
|00005b00| 53 3d 0a 40 53 45 45 41 | 4c 53 4f 3d 42 49 54 52 |S=.@SEEA|LSO=BITR|
|00005b10| 53 48 49 46 54 00 40 46 | 55 4e 43 54 49 4f 4e 3d |SHIFT.@F|UNCTION=|
|00005b20| 42 49 54 4f 52 0a 40 53 | 59 4e 54 41 58 3d 42 49 |BITOR.@S|YNTAX=BI|
|00005b30| 54 4f 52 28 61 2c 62 29 | 0a 40 44 45 53 43 52 49 |TOR(a,b)|.@DESCRI|
|00005b40| 50 54 49 4f 4e 3d 42 49 | 54 4f 52 20 66 75 6e 63 |PTION=BI|TOR func|
|00005b50| 74 69 6f 6e 20 72 65 74 | 75 72 6e 73 20 62 69 74 |tion ret|urns bit|
|00005b60| 77 69 73 65 20 6f 72 2d | 69 6e 67 20 6f 66 20 69 |wise or-|ing of i|
|00005b70| 74 73 20 61 72 67 75 6d | 65 6e 74 73 2e 0a 0a 40 |ts argum|ents...@|
|00005b80| 45 58 41 4d 50 4c 45 53 | 3d 0a 40 53 45 45 41 4c |EXAMPLES|=.@SEEAL|
|00005b90| 53 4f 3d 42 49 54 58 4f | 52 2c 42 49 54 41 4e 44 |SO=BITXO|R,BITAND|
|00005ba0| 00 40 46 55 4e 43 54 49 | 4f 4e 3d 42 49 54 52 53 |.@FUNCTI|ON=BITRS|
|00005bb0| 48 49 46 54 0a 40 53 59 | 4e 54 41 58 3d 42 49 54 |HIFT.@SY|NTAX=BIT|
|00005bc0| 52 53 48 49 46 54 28 78 | 2c 6e 29 0a 40 44 45 53 |RSHIFT(x|,n).@DES|
|00005bd0| 43 52 49 50 54 49 4f 4e | 3d 42 49 54 52 53 48 49 |CRIPTION|=BITRSHI|
|00005be0| 46 54 20 66 75 6e 63 74 | 69 6f 6e 20 72 65 74 75 |FT funct|ion retu|
|00005bf0| 72 6e 73 20 40 78 20 62 | 69 74 2d 73 68 69 66 74 |rns @x b|it-shift|
|00005c00| 65 64 20 72 69 67 68 74 | 20 62 79 20 40 6e 20 62 |ed right| by @n b|
|00005c10| 69 74 73 2e 0a 0a 2a 20 | 49 66 20 40 6e 20 69 73 |its...* |If @n is|
|00005c20| 20 6e 65 67 61 74 69 76 | 65 2c 20 61 20 6c 65 66 | negativ|e, a lef|
|00005c30| 74 20 73 68 69 66 74 20 | 77 69 6c 6c 20 69 6e 20 |t shift |will in |
|00005c40| 65 66 66 65 63 74 20 62 | 65 20 70 65 72 66 6f 72 |effect b|e perfor|
|00005c50| 6d 65 64 2e 0a 0a 40 45 | 58 41 4d 50 4c 45 53 3d |med...@E|XAMPLES=|
|00005c60| 0a 40 53 45 45 41 4c 53 | 4f 3d 42 49 54 4c 53 48 |.@SEEALS|O=BITLSH|
|00005c70| 49 46 54 00 40 46 55 4e | 43 54 49 4f 4e 3d 42 49 |IFT.@FUN|CTION=BI|
|00005c80| 54 58 4f 52 0a 40 53 59 | 4e 54 41 58 3d 42 49 54 |TXOR.@SY|NTAX=BIT|
|00005c90| 58 4f 52 28 61 2c 62 29 | 0a 40 44 45 53 43 52 49 |XOR(a,b)|.@DESCRI|
|00005ca0| 50 54 49 4f 4e 3d 42 49 | 54 58 4f 52 20 66 75 6e |PTION=BI|TXOR fun|
|00005cb0| 63 74 69 6f 6e 20 72 65 | 74 75 72 6e 73 20 62 69 |ction re|turns bi|
|00005cc0| 74 77 69 73 65 20 65 78 | 63 6c 75 73 69 76 65 20 |twise ex|clusive |
|00005cd0| 6f 72 2d 69 6e 67 20 6f | 66 20 69 74 73 20 61 72 |or-ing o|f its ar|
|00005ce0| 67 75 6d 65 6e 74 73 2e | 0a 0a 40 45 58 41 4d 50 |guments.|..@EXAMP|
|00005cf0| 4c 45 53 3d 0a 40 53 45 | 45 41 4c 53 4f 3d 42 49 |LES=.@SE|EALSO=BI|
|00005d00| 54 4f 52 2c 42 49 54 41 | 4e 44 00 40 46 55 4e 43 |TOR,BITA|ND.@FUNC|
|00005d10| 54 49 4f 4e 3d 43 41 55 | 43 48 59 0a 40 53 59 4e |TION=CAU|CHY.@SYN|
|00005d20| 54 41 58 3d 43 41 55 43 | 48 59 28 78 2c 61 2c 63 |TAX=CAUC|HY(x,a,c|
|00005d30| 75 6d 29 0a 40 44 45 53 | 43 52 49 50 54 49 4f 4e |um).@DES|CRIPTION|
|00005d40| 3d 43 41 55 43 48 59 20 | 72 65 74 75 72 6e 73 20 |=CAUCHY |returns |
|00005d50| 74 68 65 20 43 61 75 63 | 68 79 20 64 69 73 74 72 |the Cauc|hy distr|
|00005d60| 69 62 75 74 69 6f 6e 20 | 77 69 74 68 20 73 63 61 |ibution |with sca|
|00005d70| 6c 65 20 70 61 72 61 6d | 65 74 65 72 20 40 61 2e |le param|eter @a.|
|00005d80| 20 49 66 20 40 63 75 6d | 20 69 73 20 54 52 55 45 | If @cum| is TRUE|
|00005d90| 2c 20 43 41 55 43 48 59 | 20 72 65 74 75 72 6e 73 |, CAUCHY| returns|
|00005da0| 20 74 68 65 20 63 75 6d | 75 6c 61 74 69 76 65 20 | the cum|ulative |
|00005db0| 64 69 73 74 72 69 62 75 | 74 69 6f 6e 2e 0a 0a 2a |distribu|tion...*|
|00005dc0| 20 49 66 20 40 61 20 3c | 20 30 20 43 41 55 43 48 | If @a <| 0 CAUCH|
|00005dd0| 59 20 72 65 74 75 72 6e | 73 20 23 4e 55 4d 21 20 |Y return|s #NUM! |
|00005de0| 65 72 72 6f 72 2e 0a 2a | 20 49 66 20 40 63 75 6d |error..*| If @cum|
|00005df0| 20 21 3d 20 54 52 55 45 | 20 61 6e 64 20 40 63 75 | != TRUE| and @cu|
|00005e00| 6d 20 21 3d 20 46 41 4c | 53 45 20 43 41 55 43 48 |m != FAL|SE CAUCH|
|00005e10| 59 20 72 65 74 75 72 6e | 73 20 23 56 41 4c 55 45 |Y return|s #VALUE|
|00005e20| 21 20 65 72 72 6f 72 2e | 0a 0a 40 45 58 41 4d 50 |! error.|..@EXAMP|
|00005e30| 4c 45 53 3d 0a 43 41 55 | 43 48 59 28 30 2e 34 33 |LES=.CAU|CHY(0.43|
|00005e40| 2c 31 2c 54 52 55 45 29 | 20 72 65 74 75 72 6e 73 |,1,TRUE)| returns|
|00005e50| 20 30 2e 33 37 30 37 33 | 35 2e 0a 0a 40 53 45 45 | 0.37073|5...@SEE|
|00005e60| 41 4c 53 4f 3d 52 41 4e | 44 43 41 55 43 48 59 00 |ALSO=RAN|DCAUCHY.|
|00005e70| 40 46 55 4e 43 54 49 4f | 4e 3d 43 45 49 4c 0a 40 |@FUNCTIO|N=CEIL.@|
|00005e80| 53 59 4e 54 41 58 3d 43 | 45 49 4c 28 78 29 0a 40 |SYNTAX=C|EIL(x).@|
|00005e90| 44 45 53 43 52 49 50 54 | 49 4f 4e 3d 43 45 49 4c |DESCRIPT|ION=CEIL|
|00005ea0| 20 66 75 6e 63 74 69 6f | 6e 20 72 6f 75 6e 64 73 | functio|n rounds|
|00005eb0| 20 40 78 20 75 70 20 74 | 6f 20 74 68 65 20 6e 65 | @x up t|o the ne|
|00005ec0| 78 74 20 6e 65 61 72 65 | 73 74 20 69 6e 74 65 67 |xt neare|st integ|
|00005ed0| 65 72 2e 0a 0a 0a 40 45 | 58 41 4d 50 4c 45 53 3d |er....@E|XAMPLES=|
|00005ee0| 0a 43 45 49 4c 28 30 2e | 34 29 20 65 71 75 61 6c |.CEIL(0.|4) equal|
|00005ef0| 73 20 31 2e 0a 43 45 49 | 4c 28 2d 31 2e 31 29 20 |s 1..CEI|L(-1.1) |
|00005f00| 65 71 75 61 6c 73 20 2d | 31 2e 0a 43 45 49 4c 28 |equals -|1..CEIL(|
|00005f10| 2d 32 2e 39 29 20 65 71 | 75 61 6c 73 20 2d 32 2e |-2.9) eq|uals -2.|
|00005f20| 0a 0a 40 53 45 45 41 4c | 53 4f 3d 43 45 49 4c 49 |..@SEEAL|SO=CEILI|
|00005f30| 4e 47 2c 20 46 4c 4f 4f | 52 2c 20 41 42 53 2c 20 |NG, FLOO|R, ABS, |
|00005f40| 49 4e 54 2c 20 4d 4f 44 | 00 40 46 55 4e 43 54 49 |INT, MOD|.@FUNCTI|
|00005f50| 4f 4e 3d 43 45 49 4c 49 | 4e 47 0a 40 53 59 4e 54 |ON=CEILI|NG.@SYNT|
|00005f60| 41 58 3d 43 45 49 4c 49 | 4e 47 28 78 5b 2c 73 69 |AX=CEILI|NG(x[,si|
|00005f70| 67 6e 69 66 69 63 61 6e | 63 65 5d 29 0a 40 44 45 |gnifican|ce]).@DE|
|00005f80| 53 43 52 49 50 54 49 4f | 4e 3d 43 45 49 4c 49 4e |SCRIPTIO|N=CEILIN|
|00005f90| 47 20 66 75 6e 63 74 69 | 6f 6e 20 72 6f 75 6e 64 |G functi|on round|
|00005fa0| 73 20 40 78 20 75 70 20 | 74 6f 20 74 68 65 20 6e |s @x up |to the n|
|00005fb0| 65 61 72 65 73 74 20 6d | 75 6c 74 69 70 6c 65 20 |earest m|ultiple |
|00005fc0| 6f 66 20 40 73 69 67 6e | 69 66 69 63 61 6e 63 65 |of @sign|ificance|
|00005fd0| 2e 0a 0a 2a 20 49 66 20 | 40 78 20 6f 72 20 40 73 |...* If |@x or @s|
|00005fe0| 69 67 6e 69 66 69 63 61 | 6e 63 65 20 69 73 20 6e |ignifica|nce is n|
|00005ff0| 6f 6e 2d 6e 75 6d 65 72 | 69 63 20 43 45 49 4c 49 |on-numer|ic CEILI|
|00006000| 4e 47 20 72 65 74 75 72 | 6e 73 20 23 56 41 4c 55 |NG retur|ns #VALU|
|00006010| 45 21 20 65 72 72 6f 72 | 2e 0a 2a 20 49 66 20 40 |E! error|..* If @|
|00006020| 78 20 61 6e 64 20 40 73 | 69 67 6e 69 66 69 63 61 |x and @s|ignifica|
|00006030| 6e 63 65 20 68 61 76 65 | 20 64 69 66 66 65 72 65 |nce have| differe|
|00006040| 6e 74 20 73 69 67 6e 73 | 20 43 45 49 4c 49 4e 47 |nt signs| CEILING|
|00006050| 20 72 65 74 75 72 6e 73 | 20 23 4e 55 4d 21 20 65 | returns| #NUM! e|
|00006060| 72 72 6f 72 2e 0a 2a 20 | 54 68 69 73 20 66 75 6e |rror..* |This fun|
|00006070| 63 74 69 6f 6e 20 69 73 | 20 45 78 63 65 6c 20 63 |ction is| Excel c|
|00006080| 6f 6d 70 61 74 69 62 6c | 65 2e 0a 0a 40 45 58 41 |ompatibl|e...@EXA|
|00006090| 4d 50 4c 45 53 3d 0a 43 | 45 49 4c 49 4e 47 28 32 |MPLES=.C|EILING(2|
|000060a0| 2e 34 33 2c 31 29 20 65 | 71 75 61 6c 73 20 33 2e |.43,1) e|quals 3.|
|000060b0| 0a 43 45 49 4c 49 4e 47 | 28 31 32 33 2e 31 32 33 |.CEILING|(123.123|
|000060c0| 2c 33 29 20 65 71 75 61 | 6c 73 20 31 32 36 2e 0a |,3) equa|ls 126..|
|000060d0| 0a 40 53 45 45 41 4c 53 | 4f 3d 43 45 49 4c 2c 20 |.@SEEALS|O=CEIL, |
|000060e0| 46 4c 4f 4f 52 2c 20 41 | 42 53 2c 20 49 4e 54 2c |FLOOR, A|BS, INT,|
|000060f0| 20 4d 4f 44 00 40 46 55 | 4e 43 54 49 4f 4e 3d 43 | MOD.@FU|NCTION=C|
|00006100| 45 4c 4c 0a 40 53 59 4e | 54 41 58 3d 43 45 4c 4c |ELL.@SYN|TAX=CELL|
|00006110| 28 74 79 70 65 2c 72 65 | 66 29 0a 40 44 45 53 43 |(type,re|f).@DESC|
|00006120| 52 49 50 54 49 4f 4e 3d | 43 45 4c 4c 20 72 65 74 |RIPTION=|CELL ret|
|00006130| 75 72 6e 73 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |urns inf|ormation|
|00006140| 20 61 62 6f 75 74 20 74 | 68 65 20 66 6f 72 6d 61 | about t|he forma|
|00006150| 74 74 69 6e 67 2c 20 6c | 6f 63 61 74 69 6f 6e 2c |tting, l|ocation,|
|00006160| 20 6f 72 20 63 6f 6e 74 | 65 6e 74 73 20 6f 66 20 | or cont|ents of |
|00006170| 61 20 63 65 6c 6c 2e 0a | 0a 40 74 79 70 65 20 73 |a cell..|.@type s|
|00006180| 70 65 63 69 66 69 65 73 | 20 74 68 65 20 74 79 70 |pecifies| the typ|
|00006190| 65 20 6f 66 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |e of inf|ormation|
|000061a0| 20 79 6f 75 20 77 61 6e | 74 20 74 6f 20 6f 62 74 | you wan|t to obt|
|000061b0| 61 69 6e 3a 0a 0a 20 20 | 61 64 64 72 65 73 73 20 |ain:..  |address |
|000061c0| 20 20 20 09 52 65 74 75 | 72 6e 73 20 74 68 65 20 |   .Retu|rns the |
|000061d0| 67 69 76 65 6e 20 63 65 | 6c 6c 20 72 65 66 65 72 |given ce|ll refer|
|000061e0| 65 6e 63 65 20 61 73 20 | 74 65 78 74 2e 0a 20 20 |ence as |text..  |
|000061f0| 63 6f 6c 20 20 20 20 20 | 20 20 20 09 09 52 65 74 |col     |   ..Ret|
|00006200| 75 72 6e 73 20 74 68 65 | 20 6e 75 6d 62 65 72 20 |urns the| number |
|00006210| 6f 66 20 74 68 65 20 63 | 6f 6c 75 6d 6e 20 69 6e |of the c|olumn in|
|00006220| 20 40 72 65 66 2e 0a 20 | 20 63 6f 6e 74 65 6e 74 | @ref.. | content|
|00006230| 73 20 20 20 09 52 65 74 | 75 72 6e 73 20 74 68 65 |s   .Ret|urns the|
|00006240| 20 63 6f 6e 74 65 6e 74 | 73 20 6f 66 20 74 68 65 | content|s of the|
|00006250| 20 63 65 6c 6c 20 69 6e | 20 40 72 65 66 2e 0a 20 | cell in| @ref.. |
|00006260| 20 66 6f 72 6d 61 74 20 | 20 20 20 20 09 09 52 65 | format |    ..Re|
|00006270| 74 75 72 6e 73 20 74 68 | 65 20 63 6f 64 65 20 6f |turns th|e code o|
|00006280| 66 20 74 68 65 20 66 6f | 72 6d 61 74 20 6f 66 20 |f the fo|rmat of |
|00006290| 74 68 65 20 63 65 6c 6c | 2e 0a 20 20 70 61 72 65 |the cell|..  pare|
|000062a0| 6e 74 68 65 73 65 73 09 | 52 65 74 75 72 6e 73 20 |ntheses.|Returns |
|000062b0| 31 20 69 66 20 40 72 65 | 66 20 63 6f 6e 74 61 69 |1 if @re|f contai|
|000062c0| 6e 73 20 61 20 6e 65 67 | 61 74 69 76 65 20 76 61 |ns a neg|ative va|
|000062d0| 6c 75 65 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |lue.    |        |
|000062e0| 20 09 09 61 6e 64 20 69 | 74 73 20 66 6f 72 6d 61 | ..and i|ts forma|
|000062f0| 74 20 64 69 73 70 6c 61 | 79 73 20 69 74 20 77 69 |t displa|ys it wi|
|00006300| 74 68 20 70 61 72 65 6e | 74 68 65 73 65 73 2e 0a |th paren|theses..|
|00006310| 20 20 72 6f 77 20 20 20 | 20 20 20 20 20 09 09 52 |  row   |     ..R|
|00006320| 65 74 75 72 6e 73 20 74 | 68 65 20 6e 75 6d 62 65 |eturns t|he numbe|
|00006330| 72 20 6f 66 20 74 68 65 | 20 72 6f 77 20 69 6e 20 |r of the| row in |
|00006340| 40 72 65 66 2e 0a 20 20 | 77 69 64 74 68 20 20 20 |@ref..  |width   |
|00006350| 20 20 20 09 09 52 65 74 | 75 72 6e 73 20 74 68 65 |   ..Ret|urns the|
|00006360| 20 63 6f 6c 75 6d 6e 20 | 77 69 64 74 68 2e 0a 0a | column |width...|
|00006370| 2a 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |* This f|unction |
|00006380| 69 73 20 45 78 63 65 6c | 20 63 6f 6d 70 61 74 69 |is Excel| compati|
|00006390| 62 6c 65 2e 0a 0a 40 45 | 58 41 4d 50 4c 45 53 3d |ble...@E|XAMPLES=|
|000063a0| 0a 43 65 6c 6c 28 22 66 | 6f 72 6d 61 74 22 2c 41 |.Cell("f|ormat",A|
|000063b0| 31 29 20 72 65 74 75 72 | 6e 73 20 74 68 65 20 63 |1) retur|ns the c|
|000063c0| 6f 64 65 20 6f 66 20 74 | 68 65 20 66 6f 72 6d 61 |ode of t|he forma|
|000063d0| 74 20 6f 66 20 74 68 65 | 20 63 65 6c 6c 20 41 31 |t of the| cell A1|
|000063e0| 2e 0a 0a 40 53 45 45 41 | 4c 53 4f 3d 49 4e 44 49 |...@SEEA|LSO=INDI|
|000063f0| 52 45 43 54 00 40 46 55 | 4e 43 54 49 4f 4e 3d 43 |RECT.@FU|NCTION=C|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.